var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need help with bulk collect into database table type
I have following requirement: create a response to web service writing procedures in oracle.
And they need a complex type as response.
So, this is what i have created:
create or replace type efgh_type as object(
create or replace type AD_type as table of obj_ad;
create or replace type obj_ad as object of(
all these are database types.
Now this is how my procedure looks like
create or replace procedure proc_resp(id_number in varchar2, efgh out efgh_type) is
select abcd, klmn bulk collect into addr from table_1 where id_row=id_number;
while compiling am getting error as:
PL/SQL: ORA-00947: not enough values
I do not understand what am doing wrong here....what is the right way of bulk collect into database collection type???
This problem is sorted out now.
Tags for this Thread