Re: Stored Procedures and DEFAULT values for parameters

From: Martijn Tonies <m.tonies_at_upscene_nospam_.com>
Date: Mon, 1 Nov 2004 15:24:26 +0100
Message-ID: <10ochircnm6kqf5@corp.supernews.com>

Hello Tony,

> > 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!

*g* ... ok - so defaults work.

However, the Oracle documentation doesn't mention them in CREATE PROCEDURE: CREATE [ OR REPLACE ] PROCEDURE [ schema. ]procedure

   [ (argument [ IN | OUT | IN OUT ]

               [ NOCOPY ]
               datatype
       [, argument [ IN | OUT | IN OUT ]
                   [ NOCOPY ]
                   datatype
       ]...
     )

   ]
   [ invoker_rights_clause ]
   { IS | AS }
   { pl/sql_subprogram_body | call_spec }

Where exactly would they fit in?

After "datatype"?

[DEFAULT default_value]

?

-- 
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Received on Mon Nov 01 2004 - 08:24:26 CST