Weblogic JDriver for Oracle.

[Praveen.C]

Hi,
I wanted to call a PL/SQL function that opens a cursor and gets a cursor
back as a Java result set.Actually there is a readymade program in
http://www.oradoc.com/ora816/java.816/a81354/samapp5.htm#1016411
in the name RefCursorExample.java

Now what I wanted to know is in weblogic how to do that.
For example I would like you to help me to give the weblogic equivalent of a
single line in that program.

call.registerOutParameter(1, OracleTypes.CURSOR);

Instead of OracleTypes.CURSOR...what should I write for weblogic JDriver for
oracle.

Please refer to my program in the attachment. FYI weblogic is already
running when I execute the program and it creates oracle connection pools.
Please also look at the exceptions it throws below.

Exceptions are
Exception java.sql.SQLException: ORA-06550: line 1, column 15:
PLS-00382: expression is of wrong type
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
java.sql.SQLException: ORA-06550: line 1, column 15:
PLS-00382: expression is of wrong type
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
at
weblogic.rmi.extensions.AbstractRequest.sendReceive(AbstractRequest.j
ava:76)
at
weblogic.jdbc20.rmi.internal.WLStub2z3m13133166452s5z42a5c4u4a3b1v.ex
ecute(WLStub2z3m13133166452s5z42a5c4u4a3b1v.java:415)
at
weblogic.jdbc20.rmi.internal.CallableStatementStub.execute(CallableSt
atementStub.java:454)
at
weblogic.jdbc20.rmi.SerialPreparedStatement.execute(SerialPreparedSta
tement.java:401)
at OracleDataSource.main(OracleDataSource.java:49)

I would be great if you can help me out.

Sincerely,
Praveen.C