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!
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...
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...
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...
Hello,
I was asked to use REF CURSORS to solve the following problem, unfortunately I am still not able to figure it out.
The select statement in the function may return more than 1 value. I want all these values to be returned when this function is called from the java adaptors.
Will...
Thankyou for the help.
I have one more doubt. The select statement in the function may return more than 1 value. I want all these values to br returned, when this function is called from the java adaptors.
Will
CREATE OR REPLACE FUNCTION getParentNodes (nodeId NUMBER) RETURN NUMBER????? IS...
Hello,
For the following function created I am getting the listed error.
Errors for FUNCTION GETPARENTNODES:
LINE/COL ERROR -------------------------------------------------------
22/2 PL/SQL: Statement ignored
22/10 PLS-00382: expression is of wrong type
CREATE OR REPLACE FUNCTION...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.