Hi Claire,
r u using JDBC 2.0 provided by oracle. I have used the same code and is
working perfectly fine.
Mahesh.
-----Original Message-----
From: Claire Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 3:49 PM
To: [EMAIL PROTECTED]
Subject: Calling Stored Procedures
Hello all,
i am trying to call a stored procedure that returns a reference cursor from
Oracle. All my attempts have resulted in these errors.
I have tried the following:
(1)callableStatement.registerOutParameter(1,OracleTypes.CURSOR);
This gives me this error:
*** Error: "OracleTypes/CURSOR" is either a misplaced package name or a
non-existent entity. An expression name is expected in this context
(2)callablestatement.registerOutParameter(1,Types.OTHER);
This gives me these errors:
Errors with Procedure[Microsoft][ODBC driver for Oracle]Cannot bind PL/SQL
Records or Cursor References
Errors again java.sql.SQLException: [Microsoft][ODBC driver for
Oracle]Cannot bind PL/SQL Records or Cursor References
Any help that anybody can give me with this would be greatly appreciated.
Thanks in advance,
Claire Ryan.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
