OraFAQ Forum: Windows » how to execute oracle procedure with out parameter

Home » Infrastructure » Windows » how to execute oracle procedure with out parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to execute oracle procedure with out parameter [message #99794]

Thu, 04 April 2002 10:02

Galina
Messages: 3
Registered: April 2002

Junior Member

I'm trying to execute oracle procedure expecting to return for example number. Procedure doesn't expect any IN parameter, so why I just calling my procedure. I'm getting an error: Wrong number of arguments? What I'm doing wrong. Any suggestions are welcome. Thanks.

Report message to a moderator

Re: how to execute oracle procedure with out parameter [message #99795 is a reply to message #99794]

Thu, 04 April 2002 10:08

saleem
Messages: 65
Registered: January 2002

Member

if it's a procedure you are calling (e.g. procedure_name(variable out number) ) then the appropriate call to this procedure is :
procedure_name(return_variable);

if it's a function you are calling then :
return_variable := function_name;

however, based on the fact that the error is complaining about the # of arguments being passed, my guess is that this is the first situation i outlined.

Report message to a moderator

Re: how to execute oracle procedure with out parameter [message #100317 is a reply to message #99794]

Thu, 10 October 2002 21:09

Sudheer
Messages: 19
Registered: July 1999

Junior Member

Hi galina,

before exititng out of your sub programme explicitly assign value to all theout variables.

then write an anonymous block,where you decalre a variable of the datatyep you have given in the procedure and pass this variable.You would get the output value into this variable.

Hope this works for u.
Sudheer.

Report message to a moderator