Worrow Posted June 9, 2009 Posted June 9, 2009 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.:D p.s. Of course I could find other way to around it by using ref_cursor or get the size of result set first. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.