Forum Stats

  • 3,874,528 Users
  • 2,266,750 Discussions
  • 7,911,880 Comments

Discussions

how to call Oracle Store procedure with CollectionTypes and ObjectTypes

User_6UUQC
User_6UUQC Member Posts: 1 Green Ribbon

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