default values for parameters?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Posts: 64
Joined: Wed 04 Jan 2006 15:32

Post by 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: ... ments.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'
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

Posts: 2756
Joined: Mon 13 Mar 2006 07:43

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

Post Reply