Hi,
I have a question about calling a Oracle sp with several output parameters of Associated Array type. I got no problem to get them working as long as I defined the size of each parameter. However, since the size is supposed unknown in that stage. So exception will be thrown if my result set is bigger than the one I had defined. Is it possible to working with associated array without define the size (except the field width for varchar2)?
Thanks in advance.
p.s. Of course I could find other way to around it by using ref_cursor or get the size of result set first.
I have a question about calling a Oracle sp with several output parameters of Associated Array type. I got no problem to get them working as long as I defined the size of each parameter. However, since the size is supposed unknown in that stage. So exception will be thrown if my result set is bigger than the one I had defined. Is it possible to working with associated array without define the size (except the field width for varchar2)?
Thanks in advance.
p.s. Of course I could find other way to around it by using ref_cursor or get the size of result set first.