Home » SQL & PL/SQL » SQL & PL/SQL » "illegal variable name/number" error when one more OUT param along with a ref cursor
"illegal variable name/number" error when one more OUT param along with a ref cursor [message #38334] Thu, 11 April 2002 04:56 Go to next message
Amit
Messages: 166
Registered: February 1999
Senior Member
Hi

I have a PL/SQL procedure that takes 3 parameters (ename IN varchar2,
x OUT varchar2, e_refcur OUT refcursor)
I am calling this proc from java code using Oracle oci8 jdbc driver.

When I make the 2nd parameter as IN OUT it works fine.
But with parameter x as OUT it fails giving error that "illegal
variable name/number"

Does anyone know whether I can have any additional OUT params in
PL/SQL procedure when one parameter is already OUT RefCursor type ???
What's the problem and solution for my case ???

Please reply at earliest...

Amit

Report message to a moderator

Re: "illegal variable name/number" error when one more OUT param along with a ref cursor [message #38335 is a reply to message #38334] Thu, 11 April 2002 05:51 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
well,officially speaking , u can have as many OUT paramaters as you want (no matter how many ref cursors u have).

I think the easiest fix for ur problem is to change ur e_refcursor to 'IN OUT' parameter in your procedure/package!

Regards
Oraboy

Report message to a moderator

Previous Topic: VERY URGENT: HOW CAN I ROUND A NUMERIC VALUE UP TO THE HUNDREDS.
Next Topic: Name of seven days
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 13:28:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.