Not able to print the value of multiple refcursor in .net.
procedure :
- CREATE OR REPLACE PROCEDURE getEmpNames
- (
- commissioned IN OUT SYS_REFCURSOR,
- salaried IN OUT SYS_REFCURSOR
- )
- IS
- BEGIN
- OPEN commissioned FOR SELECT ename FROM emp WHERE comm is NOT NULL;
- OPEN salaried FOR SELECT ename FROM emp WHERE comm is NULL;
- END;
.net code
- public void RefCursorSample(Connection con)
- {
- try
- {
- con.setAutoCommit(false);
- String commandText = "{call getEmpNames(?,?)}";
- CallableStatement stmt = con.prepareCall(commandText);
- stmt.setNull(1, Types.REF);
- stmt.registerOutParameter(1, Types.REF);
- stmt.setNull(2, Types.REF);
- stmt.registerOutParameter(2, Types.REF);
- stmt.execute();
- ResultSet commissioned = (ResultSet)stmt.getObject(1);
- System.out.println("Commissioned employees:");
- while(commissioned.next())
- {
- System.out.println(commissioned.getString(1));
- }
- ResultSet salaried = (ResultSet)stmt.getObject(2);
- System.out.println("Salaried employees:");
- while(salaried.next())
- {
- System.out.println(salaried.getString(1));
- }
- }
- catch(Exception err)
- {
- System.out.println("An error has occurred.");
- System.out.println("See full details below.");
- err.printStackTrace();
- }
- }
Rajanikant HawaldarPosted Sep 5, 2019, 8:53 PM
Rajanikant HawaldarPosted Sep 5, 2019, 8:52 PM
Abhijeet JadhavPosted Sep 5, 2019, 11:14 AM