Hi I have been trying to get my .NET framework API to work in calling a stored procedure with Collection Types and Object Types but cant seem to figure it out
CREATE OR REPLACE Procedure ADMIN_USER.test_Info
P_Info tp_tbl_Info
and in Collection Types
CREAT OR REPLACE type ADMIN_USER.tp_tbl_Info is table of tp_rec_Info;
and in Object Types
CREATE OR REPLACE type ADMIN_USER.tp_rec_Info is object
(
ID VARCHAR2(10),
NAME VARCHAR2(100)
);
and the .NET Framework has Oracle.ManagedDataAccess
OracleParameter param1 = new OracleParaMeter("P_INFO", OracleDbType.Varchar2, ParameterDirection.Input);
param1.UdtTypeName = "ADMIN_USER.tp_tbl_Info";
param1.Value = null;
how do i pass a value for param1.Value? Thanks I appreciate it