OraFAQ Forum: Forms » Procedure without all the parameters sent to it

Home » Developer & Programmer » Forms » Procedure without all the parameters sent to it

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

Procedure without all the parameters sent to it [message #220000]

Sat, 17 February 2007 08:43

Lama
Messages: 45
Registered: February 2006

Member

is there a way that a procedure works without all the procedure sent to it, ex. if I have this procedure -->
get_message( p_msg_code in number, p_msg out varchar2, p_added_to_msg in varchar2)
could I call the procedure with only the two parameters -->

Get_message(1,v_message);

this is already available in built in packages in oracle so I think this can be done but am not sure how??? can anyone help me...

Report message to a moderator

Re: Procedure without all the parameters sent to it [message #220003 is a reply to message #220000]

Sat, 17 February 2007 09:05

Frank
Messages: 7901
Registered: March 2000

Senior Member

This can be done by defining a default value for the parameters when creating the procedure.

create or replace procedure get_message
( p_msg_code in number
, p_msg out varchar2
, p_added_to_msg in varchar2 := null
)

Report message to a moderator

Re: Procedure without all the parameters sent to it [message #220004 is a reply to message #220003]

Sat, 17 February 2007 09:14

Lama
Messages: 45
Registered: February 2006

Member

thanx alot, I knew that it's simple am not sure why i didn't try it before...anyway thanks for your fast reply

Report message to a moderator

Previous Topic:	same LOV can fetch differet record for different user ?
Next Topic:	forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 22:11:45 CST 2025