Home » SQL & PL/SQL » SQL & PL/SQL » why a parameter type number can get default 0?
why a parameter type number can get default 0? [message #37387] Tue, 05 February 2002 00:11 Go to next message
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
Re: why a parameter type number can get default 0? [message #37389 is a reply to message #37387] Tue, 05 February 2002 03:21 Go to previous message
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.
Previous Topic: Re: Linking table fields in oracle
Next Topic: Combine Duplicates
Goto Forum:
  


Current Time: Tue Sep 28 11:47:11 CDT 2021