Stored Procedures and DEFAULT values for parameters

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

-- 
With regards,

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