Hi,
I need a sample code in ASP or VB wherein ADO command object is used to invoke oracle stored procedure. The stored procedure (SP) should have oracle specific custom data types (CDT) as input/output arguments. Consider following statements to define CDT and SP in Oracle.
CREATE OR REPLACE TYPE UDT01 AS OBJECT (UNAME VARCHAR2(20), PWD VARCHAR2(20));
'create or replace procedure TEST_SP_UDT (INP1 IN UDT01, OP1 OUT UDT01) AS
BEGIN
OP1 := INP1;
END;
Can someone provide a sample on how can populate the parameters for the SP and invoke it to retrieve the output?