How can I retrieve metadata with ODAC?

[ivsal]

I need the Oracle data type of SPs parameters.

[Alex]

You can use TOraStoredProc object, set the StoredProcName property to desired value, and Prepare it. In Params you will get all stored proc parameters with they types. Alternative way is to use SQL query, for example something like this:

Code: Select all

SELECT argument_name, data_type, in_out, data_length, data_precision, data_scale, default_value
FROM sys.all_arguments WHERE object_name = :MyStoredProcName AND owner = :MySchema AND data_level = 0 AND package_name IS NULL ORDER BY 1