CORSORS

[NitinJain]

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

be able to handle more than one value and return them to the java program.

Regards

 

[Turkbear]

Hi,
Check your docs for REF CURSORS ;

They are what you need to do that...


hth,