how to check programatically wether a oracle stored procedure has default valued parameters?
- From: "hiten" <hituin@xxxxxxxxxxxxxx>
- Date: 31 Jul 2006 22:13:27 -0700
I want to get the collection OracleParameter[] of all the stored
procedure parameters which are assigned default values in stored proc.
The way in which I was trying out was to get the parameter array with
the help of OracleCommandBuilder.DeriveParameter() method. But this
method only gives the name,datatype,size,isnullable properties of the
parameter.This method does not gives any property to check if the
parameter has default value or not.
So issues are;-
1> How to check if the parameter has default value or not?
2> How to get that default value?
thanx
.
- Follow-Ups:
- Re: how to check programatically wether a oracle stored procedure has default valued parameters?
- From: Miha Markic [MVP C#]
- Re: how to check programatically wether a oracle stored procedure has default valued parameters?
- Prev by Date: RE: Oracle Client ORA-03113 error hangs my windows service
- Next by Date: RE: Traverse a Many-to-Many relationship
- Previous by thread: DataTable, Delete, GetChanges, Merge....What's wrong?
- Next by thread: Re: how to check programatically wether a oracle stored procedure has default valued parameters?
- Index(es):