1. Returning the resultset as Varray to ibatis Hashmap stackoverflow.comI have written plsql stored procedure , The procedure returns the mulitple rows as VARRAY . Can i use Ibatis HashMap as the return type in the config xml file. |
2. Execute anonymous pl/sql block and get resultset in java stackoverflow.comI would like to execute the anonymous PL/SQL and need to get the resultset object. I got the code which can be done by using cursors inside the PL/SQL block. But the ... |
3. Resultset returned by PL/SQL function coderanch.comHi, We are using an Oracle Database and we have a PL/SQL function wich returns a resultSet (get back in a java code program on a callableStatement as an OracleTypes.CURSOR). The problem is that that resultset is forward only and we have no idea how to modify the PL/SQL function or the client java code (wich call the function) to make ... |
4. Get ResultSet by executing anonymous pl/sql block. coderanch.comHi all, We are using Oracle with PL/SQL. I am using an anonymous blocks to get the data. I need to run about four different select queries and be able to navigate through it. It will have to have loops within loops. I did a similar thing in Java and i just assigned all the results to a Vector (or I ... |
5. Need help.....Calling a pl/sql function from java code to print a resultset forums.oracle.com |
6. Execute anonymous pl/sql block and get resultset in java. forums.oracle.comHello All, I would like to execute the anonymous pl sql block and need to get the resultset object. I got the code which can be done by using cursors inside the pl sql block. But the pl sql block itself will come from the database as text. So i cant edit that pl sql block. And it will return only ... |