>>I have a stored procedure written in PL/SQL, which I'm
>>attempting to call from Cold Fusion, but only errors are
>>generated.
>>
>>Here is the stored procedure:
>
>
> Unfortunately, it didn't come through. But anyway, have you tried calling
> this stored procedure from SQL*Plus? How about from another Java client? You
> might try using ViennaSQL, which I've found helpful for diagnosing problems
> occasionally.
Yep, I've called it from SQL*Plus, and it works as expected.
I'll look into ViennaSQL. I currently use the free version of TOAD,
which doesn't (as far as I can tell) allow me to test stored procedures.
--
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]
