Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Passing Data in Native SQL stored Procedures

Former Member
0 Kudos

Hi all,

We are connecting to a stored procedure in Oracle from a user exit. We have managed to send through small character variables but would like to pass through a large complex structure which can be interpretted and used by the Oracle db.

What options do we have to send this large data object through.

Your help is appreciated.


Active Contributor
0 Kudos


I am not sure.Just try the following and create a table in oracle(say zzz_table) similar to the one in SE11.

data wa type zzz_table.

select * from zzz_table into wa where regno = '33'.

exec sql.

create or replace procedure prod1 ( m in zzz_table ) is


insert into student ( regno, name, percentage )

values ( &m-regno, &m-name, &m-percentage );


execute procedure prod1 ( in :wa)

Kindly reward points by clicking the star on the left of reply,if it is helpful.

0 Kudos

Thanks for the posting - this does not really help me though. We need to send through a complex structure and I am not sure what data types are supported - and maybe this is the bottom line question. We need to send information through that will effectively map to an Oracle user defined type which is structured and nested etc.

I hope this is clearer.