Re: how to check programatically wether a oracle stored procedure has default valued parameters?

From: "Miha Markic [MVP C#]" <miha at rthand com>
Date: Tue, 1 Aug 2006 13:20:33 +0200

Hi

I would resort to Oracle DDL (using sql statements to query for the values
required) - sorry, I don't know the syntax out of my head.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"hiten" <hituin@xxxxxxxxxxxxxx> wrote in message
news:1154409207.548381.46100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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: Frans Bouma [C# MVP]

References:
- how to check programatically wether a oracle stored procedure has default valued parameters?
  - From: hiten

Prev by Date: Re: SqlClient Connections created don't get reused in the pool and cause error in ASP.NET Page
Next by Date: Re: Binding to two dataviews
Previous by thread: how to check programatically wether a oracle stored procedure has default valued parameters?
Next by thread: Re: how to check programatically wether a oracle stored procedure has default valued parameters?
Index(es):
- Date
- Thread

Relevant Pages

RE: EXISTS reserved word in FROM clause
... we make a good pair because I know Access SQL ... from what you described the query syntax that I ... >The subquery should return the records: ...
(microsoft.public.access.queries)
Re: Exclusive Form
... You're using the syntax for an UPDATE query, ... "'", dbFailOnError ... I created a new table called FormLock with one field named ...
(microsoft.public.access.formscoding)
Re: SELECT * or list fields?
... SELECT * is used in a query. ... As reagards maintenance, adding columns to the table is not so bad but ... As regards SQL statements ('query' is often used in the ...
(microsoft.public.access.queries)
Re: Bizarre subquery syntax problem
... With Access, the official syntax for a subquery always requires an alias, so ... SELECT p.AS UID, p.Firstname AS Firstname, p.Lastname AS Lastname, ... I am seeing bizarre problems with a subquery. ... core query runs fine- ...
(microsoft.public.access.queries)
Re: PSP
... I'd be interested in your opinions on syntax of PSP... ... Furthermore, if a query fails, it does not ... > look like it allows the programmer to directly mix the Prolog and HTML. ... Another downside is that predicates cannot be ...
(comp.lang.prolog)