default values for parameters?

Postby kevinherring » Thu 26 Jul 2007 11:12

Thanks Alexey, you've been really helpful.

I stuck sys.dbms_describe.describe_procedure into google and came up with this guys blog:
http://mennan.kagitkalem.com/WhereIsDefaultValuesOfProcedureArguments.aspx
This was only posted in June, which is why I didnt find it before.

Anyway I settled on the following if anyone is interested:
Code: Select all
SELECT o.NAME, a.procedure$, a.argument, a.default#, a.default$
FROM sys.obj$ o, sys.argument$ a
WHERE o.obj# = a.obj#
and a.procedure$ = 'MY_PROCEDURE'
AND o.NAME like 'MY_PACKAGE'


Unfortunately it doesnt seem that you can actually get the default value, only that it has one. This is good enough for me, but it would be nice if you could get the default value too.

Using the OCI call I mentioned above seemed like a lot of effort and parsing all_source would be slow.....

Thanks again
Kevin
kevinherring
 
Posts: 64
Joined: Wed 04 Jan 2006 15:32

Postby Alexey » Thu 26 Jul 2007 12:42

but it would be nice if you could get the default value too.
This appears to be very complicated. Maybe in distant future...
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Previous

Return to dotConnect for Oracle