Recent content by NitinJain

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...

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...

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...

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())...

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...

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...

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...

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

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...

Thanks everyone for the prompt replys. Regards Nitin

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

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...

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

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

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...