How to get stored procedure parameter types and sizes in Oracle?

2018-06-06 13:06:19

To call a stored procedure with output parameters from C#, I need to obtain the datatype and the size of the respective parameters. I am using the Oracle.DataAccess library. How can I get this information from stored procedure metadata on an Oracle database?

Someone gave the tables to query for SQL Server in this answer (How to determine size property for stored procedure output parameters in C# data access layer), however I'm looking to call stored procedures in Oracle.

这是查询

select  a.OBJECT_NAME, data_type, sequence, in_out, data_length, data_precision, Data_scale, radix
from USER_PROCEDURES P inner join USER_ARGUMENTS a on P.OBJECT_NAME = a.OBJECT_NAME
where a.OBJECT_NAME = 'Stored Proc name'
order by sequence

链接地址: http://www.djcxy.com/p/20294.html

上一篇: C＃数据表到Oracle存储过程

下一篇: 如何在Oracle中获取存储过程参数类型和大小？