Home » Developer & Programmer » Forms » Procedure without all the parameters sent to it
Procedure without all the parameters sent to it [message #220000] Sat, 17 February 2007 08:43 Go to next message
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...
Re: Procedure without all the parameters sent to it [message #220003 is a reply to message #220000] Sat, 17 February 2007 09:05 Go to previous messageGo to next message
Frank
Messages: 7880
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
) 


Re: Procedure without all the parameters sent to it [message #220004 is a reply to message #220003] Sat, 17 February 2007 09:14 Go to previous message
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
Previous Topic: same LOV can fetch differet record for different user ?
Next Topic: forms
Goto Forum:
  


Current Time: Sat Dec 10 18:31:34 CST 2016

Total time taken to generate the page: 0.07636 seconds