Dynamic SQL question.

From: <odessa7_at_my-dejanews.com>
Date: Thu, 29 Apr 1999 03:00:39 GMT
Message-ID: <7g8i0l$e82$1@nnrp1.dejanews.com>

Greetings!

I need to create a dynamic select statement and return a result set back to Java calling env.

Suppose, I built my dynamic select as 'SELECT fname, lname FROM emp where ssn = :x'

What do I do next? I heard I need to use DBMS_SQL package. How do I get a result set back from DBMS_SQL I can return a cursor/or array back to java caller? Any code sample is appreciated.

L.B.
oracle_at_russiantreasure.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 22:00:39 CDT