Hi,
I have a PL/SQL procedure of following structure
CREATE OR REPLACE PROCEDURE proc1(param1 IN VARCHAR2,param2 IN VARCHAR2)
IS
BEGIN
-----Statements goes here
END;
/

Can I call the procedure like this
execute proc1('ssk',)
ie without passing any value to the second pramater?

becos my requirement is that the param2 is optional
if I call the procedure like "execute proc1('ssk',)"
I get the error message..............

So can any one please tell me how to handle this situation.
Thanks in advance.
Regards,
Senthil

Yes you can:

You'll have to declare a defualt value for the in parameter though:

[REMI@ORA-0000.COM] CREATE OR REPLACE PROCEDURE proc1
2 ( param1 IN VARCHAR2,
3 param2 IN VARCHAR2 DEFAULT NULL)
4 IS
5 BEGIN
6 NULL;
7 END;
8 /

Procedure created.

[REMI@ORA-0000.COM] EXEC proc1('Hello')

PL/SQL procedure successfully completed.

Good luck!!

Thanks a Lot
Regards,
Senthil