>
> -----Original Message-----
> From: Richard Crawford
> Sent: Tuesday, February 24, 2004 3:24 PM
> To: CF-Talk
> Subject: Re: Cold Fusion and Oracle Stored Procedures
>
>
> > CREATE OR REPLACE procedure dlc_sp_getStudentInfo (
> > studentID IN int,
> > studentInfo in out types.cursorType
> > )
>
> AFAIK, you can't pass a cursor in from CF, so why is studentInfo in out?
> Might as well just use an out ref cursor.
Thanks for the suggestion. I simply followed the example I found on
line, tailoring a bit for my needs. I should mention that I do have a
package, declared elsewhere, called "types", where cursorType is defined.
> Can you run your procedure directly in Oracle?
It compiles just dandy.
--
Richard S. Crawford
Programmer/Analyst III,
UC Davis Extension Distance Learning Group
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
