View Single Post
  #6 (permalink)  
Old 08-18-06, 04:31
RBARAER RBARAER is offline
Registered User
 
Join Date: Aug 2004
Location: France
Posts: 754
Yes, OCCI allows you to get Metadata for almost every object in the database (provided you have the rights on these objects), including procedures. So you can get the parameters from a procedure as well as their type, and then metadata related to this type if it is an Object or Collection Type.

I haven't used this personally but the colleague I spoke of used it and it proved to be very useful to us.

HTH & Regards,

rbaraer
__________________
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .
Reply With Quote