Passing structure to PL/SQL package/procedure via Pro*C

From: comp.unix.programmer <ml_mobile_at_hotmail.com>
Date: Thu, 2 Oct 2003 15:07:27 +0800
Message-ID: <3f7bccb7$1_2@news.tm.net.my>

Hi,

Is it possible to pass in and out a structure to a procedure/package in Embedded PL/SQL block?

Assuming I have the following codes:
create type struct_obj is object (
prefix varchar2(3),
no integer,
);
create type struct_tbl is table of struct_obj;

I used the OTT to generate a header file from the above types.

When I precompile the follwoing codes, I get error PLS-S-00306, wrong number or types of arguments in call to 'proc'.   EXEC SQL EXECUTE
    BEGIN
      pkg_test.proc(:my_struct);
    END;
  END-EXEC; I tried passing a C structure to the procedure also hitting the same error.

Could any one help?

Thanks,
Max Received on Thu Oct 02 2003 - 02:07:27 CDT