Home » SQL & PL/SQL » SQL & PL/SQL » HOw to find out the procedure/Function/Package parmater having default vlaue used (Oracle10g)
HOw to find out the procedure/Function/Package parmater having default vlaue used [message #402901] Wed, 13 May 2009 00:52 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,

SELECT ua.*,
FROM   user_arguments ua
WHERE  ua.object_name = 'TEST';

It gets all the parmeter information.But it never tell whether it is default parameter or not.
From where i get all the parmeter information with defualt value.

[Updated on: Wed, 13 May 2009 00:57] by Moderator

Report message to a moderator

Re: HOw to find out the procedure/Function/Package parmater having default vlaue used [message #402904 is a reply to message #402901] Wed, 13 May 2009 01:05 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What about the column DEFAULT_VALUE?
Re: HOw to find out the procedure/Function/Package parmater having default vlaue used [message #402907 is a reply to message #402901] Wed, 13 May 2009 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot have the default value, you can just know there is a default value or not.

Regards
Michel
Re: HOw to find out the procedure/Function/Package parmater having default vlaue used [message #402908 is a reply to message #402907] Wed, 13 May 2009 01:13 Go to previous messageGo to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,
I want to know that,If any parmater holds default value .How can I get this .Above select query gives only parameter name with datatype,But what about default parameter?
Re: HOw to find out the procedure/Function/Package parmater having default vlaue used [message #402911 is a reply to message #402908] Wed, 13 May 2009 01:19 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot get if a parameter has a default value from %_arguments views, you have to query sys.argument$.default#.

Regards
Michel

[Updated on: Wed, 13 May 2009 01:28]

Report message to a moderator

Previous Topic: Oracle_XML
Next Topic: PL/SQL coding verification tool
Goto Forum:
  


Current Time: Wed Dec 07 22:16:42 CST 2016

Total time taken to generate the page: 0.06238 seconds