innovate
asked on
List of stored procedures?
I'm using ADO to execute Oracle stored procedures, I'm trying to enumerate the stored procedures and check the actual datatype values so I can select the correct ADO type. I used..
"SELECT Distinct Name FROM user_source"
but only got a list of packages containing the stored procedures when I thought I was going to get the porcedures.
What's the correct source for the stored procedure names?
"SELECT Distinct Name FROM user_source"
but only got a list of packages containing the stored procedures when I thought I was going to get the porcedures.
What's the correct source for the stored procedure names?
view all_objects shows you only procedures that current logged user can access. dba_objects shows all stored ones.
The following query may be help for u...
select object_name from all_objects where object_type ='PROCEDURE'
thanks
select object_name from all_objects where object_type ='PROCEDURE'
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
P.S. of course all the non-packaged procedures/functions
are also listed (with datatype of the arguments; that's
what you wanted?)
are also listed (with datatype of the arguments; that's
what you wanted?)
Not an technical update, but just a concern for the proposed answer. Appreciate if you could read the updates to the question, before you post your answer. It doesn't look good to propose an answer when somebody has already given that as a comment.
try out with this
SELECT Distinct Name FROM user_source where type='PROCEDURE'
SELECT Distinct Name FROM user_source where type='PROCEDURE'
ASKER
Thanks for the comments all.
select object_name from all_objects where object_type ='PROCEDURE';
The above query will give you only the name of the procedures in the database. You can restrict the query further by adding another predicate like owner='SCOTT'.