Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NitinJain

  1. NitinJain

    Stored Procedure execution

    Hello! I have executed the following stored procedure without any errors in Oracle 8, but have been getting paranthesis error in the select statement for Oracle9i. The stored procedure is............. CREATE OR REPLACE FUNCTION getData (thisNode NUMBER) RETURN VARCHAR IS...
  2. NitinJain

    Parantheses error in Select statement.

    Hello! I have executed the following code without any errors in Oracle8, but give an error related to the parantheses when executed in oracle 9i. CODE:::: ... ... ... SELECT (NodeType = 3 OR NodeType = 4 OR NodeType = 8)????? INTO nodeIsText FROM t_Node...
  3. NitinJain

    How to execute a cursor from SQL prompt.

    Hello, I have defined the following function getParentNodes in the package t_Nodes. When this function is execute, it should return more than one row. ==================== CREATE OR REPLACE PACKAGE t_Nodes IS TYPE parentNodeId IS REF CURSOR; FUNCTION getParentNodes(nodeId NUMBER) RETURN...
  4. NitinJain

    Parameter Type Conflict

    Hello, I have java function which when used executes a stored procedure which inturn returns a VARCHAR value. The java function: public String getDocumentName () { try { System.out.println("DBDocument getDocumentName() ID : " +super.getId())...
  5. NitinJain

    PL/SQL

    Hello, I have defined a simple function as follows: CREATE OR REPLACE FUNCTION isValidName (theString VARCHAR) RETURN BOOLEAN IS BEGIN RETURN TRUE; END isValidName; I was trying to test it by executing the following: SET SERVEROUT OFF BEGIN dbms_output.put_line( isValidName...
  6. NitinJain

    Compatiblity Of JDBC Drivers

    Hello, I have java files which can be complied by jdk1.3 and higher versions. Oracle version that I am using is 8. I downloaded JDBC drivers from oracle website which are for jdk1.3 but compt. with Oracle9i as stated on the site. Can they still work for Oracle8? By using these I am getting...
  7. NitinJain

    Hello! I have been facing followin

    Hello! I have been facing following problem. The setAttributeNode function gets created successfully, but while testing if the parameter values are passed, I get the listed error: ORA-01403: no data found for the following select statement: SELECT child_node_id INTO currAttr...
  8. NitinJain

    PL/SQL

    Hello Sem, Sorry to tell you that I am still getting the same error. Can you suggest me something else? Regards
  9. NitinJain

    PL/SQL

    Hello! I have been facing following problem. The setAttributeNode function gets created successfully, but while testing if the parameter values are passed, I get the listed error: ORA-01403: no data found for the following select statement: SELECT child_node_id INTO...
  10. NitinJain

    PL/SQL

    Thanks everyone for the prompt replys. Regards Nitin
  11. NitinJain

    PL/SQL

    Thankyou Vikram for the reply. Is there any other way to handle this situation as it can be done in Postgres using select createDocument ('namespaceUri', 'qualifiedName', NULL) \g /dev/null Regards
  12. NitinJain

    PL/SQL

    Hello, I am getting the shown error for the following select statement. select createDocument ('namespaceUri', 'qualifiedName', NULL) from dual; ORA-06571: Function APPENDCHILD does not guarantee not to update database createDoument is a stored function with the following code: CREATE OR...
  13. NitinJain

    COALESCE declaration

    Sorry Bimal, I have found out that Coalesce expression is only available from 9i. Thanks for your help. Nitin
  14. NitinJain

    COALESCE declaration

    Hello Bimal, I think Coalesce expresson is available from Oracle version 8. http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58232/apc.htm Regards Nitin
  15. NitinJain

    COALESCE declaration

    Hello, I am using the given insert statement while creating a function, but it gives the following error. LINE/COL ERROR ------------------------------------------------------- 65/2 PL/SQL: SQL Statement ignored 70/6 PLS-00201: identifier 'COALESCE' must be declared INSERT INTO t_arch...
See more

Part and Inventory Search

Back
Top