Devart Forums

Posted: **Sat 11 Jun 2005 13:56**

I need the Oracle data type of SPs parameters.

Posted: **Tue 14 Jun 2005 12:18**

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

Devart Forums

How can I retrieve metadata with ODAC?

How can I retrieve metadata with ODAC?