Hello ,
I am trying to use stored procedures instead of embedded sequels.I am stuck in creating the stored procedure for a simple select statement and retrieving the results back in my programme.Could any one please send me a sample code of both the stored proc and the
java code.In fact i want to know how do i retrieve multiple results in my programme.
I am using Oracle 8i.
Thanks
Prashanth