OraFAQ Forum: SQL & PL/SQL » why a parameter type number can get default 0?

Home » SQL & PL/SQL » SQL & PL/SQL » why a parameter type number can get default 0?

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

why a parameter type number can get default 0? [message #37387]

Tue, 05 February 2002 00:11

MarcoC
Messages: 10
Registered: February 2002

Junior Member

Hi,
I have a procedure that compiles well with the following syntax:

CREATE OR REPLACE procedure A (v_num in number default 0) is ...

but when I test it without passing the parameter, v_num doesn't get the default 0 and remains NULL,
does anybody know why? Thanks,

Marco

Report message to a moderator

Re: why a parameter type number can get default 0? [message #37389 is a reply to message #37387]

Tue, 05 February 2002 03:21

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

look at my test case

SQL> create procedure a_proc(a number default 0) is
2 begin
3 dbms_output.put_line(a);
4 end;
5 /

Procedure created.

SQL> exec a_proc
0 <<<----

PL/SQL procedure successfully completed.

Report message to a moderator

Previous Topic:	Re: Linking table fields in oracle
Next Topic:	Combine Duplicates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 29 16:33:11 CDT 2026