Martijn Tonies wrote:
> Hi there,
>
> I cannot seem to figure out if a procedure parameter
> can have a default value, eg something like:
>
> create procedure def_test (pin_1 int default 4)
> as
> ...
> <stuff>
>
> It seems to compile, but...
>
> If this is accepted, the default value doesn't seem to
> show up in ALL_ARGUMENTS.DEFAULT_VALUE
>
> Any idea what I'm doing wrong, if anything?
>
> I seem to remember that this could be done...
It can be done, your code is OK. The problem is that the DEFAULT_VALUE
column in ALL_ARGUMENTS doesn't work!
Received on Mon Nov 01 2004 - 08:03:15 CST
