Deanna Schneider wrote:

> Have you tried using GenericCursorType for your cursor type? That works for
> me. (I can give you a sample stored proc that's working for me, if that
> would be helpful.)

I'd appreciate that.  I tried using GenericCursorType, and the SP would
not compile, throwing this error:
===========================================================
PLS-00201: identifier 'GENERICCURSORTYPE' must be declared
===========================================================

Here is how I tried to implement it:
===========================================================
CREATE OR REPLACE procedure dlc_sp_getStudentInfo (
studentID IN number,
studentInfo OUT GenericCursorType
)
===========================================================

--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to