Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems with default parameter values
Maybe using CONSTANT would help your situation......
Its unclear whether you meant parameter(can change) or constant (doesnt change)
cn_item_text_length CONSTANT NUMBER(2) := 69; cn_item_amount_length CONSTANT NUMBER(2) := 19;
good luck
george
"Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message news:<4111e4f3$1_at_post.usenet.com>...
> **** 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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Thu Aug 05 2004 - 11:15:06 CDT