Re: problems with default parameter values

• Post for FREE via your newsreader at post.usenet.com ****

Hi Kevin

> These worked fine when the parameter was a varchar but for anything else
it
> would not work.

What does this mean? The default value was not used, you get an error or something else....

> everything worked fine. The documentation states that := should be use for
> defining default numerics. something like
>
> p2 in number := 7
>
> which would seem to imply that null in place of 7 should be ok. But it's
> not.
>
> Is this an error in the documentation?

According to the documentation both can be used. http://download-west.oracle.com/docs/cd/B13789_01/appdev.101/b10807/13_elems036.htm#sthref1788

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=