"Michael A Chase" <[EMAIL PROTECTED]> wrote in message Mahogany-0.64.2-4056-20020821-100946.00@MCHASE-COMPAQ">news:Mahogany-0.64.2-4056-20020821-100946.00@MCHASE-COMPAQ... > On Wed, 21 Aug 2002 13:16:14 +0200 PHleX <[EMAIL PROTECTED]> wrote: > > >"Michael A Chase" <[EMAIL PROTECTED]> wrote in message Mahogany-0.64.2-3260-20020726-082723.00@MCHASE-COMPAQ">news:Mahogany-0.64.2-3260-20020726-082723.00@MCHASE-COMPAQ... > > > On Fri, 26 Jul 2002 11:16:00 +0530 "Sundarraj, Senthil Kumar (Cognizant)"<[EMAIL PROTECTED]> wrote: > > > > > : kind of "Very easy to do, but I've never done it..." idea :-/ to make > > PL/SQL pick the element you need instead of picking up the whole table and > > then work on it from perl > > (http://www.bitmechanic.com/mail-archives/dbi-users/Feb1997/0048.html). This > > doesn't meet my needs since I have to get the whole table in a single call > > to my stored function. > > How about spliting the string up into the desired components in Perl? Perl > is much better at string and array handling than PL/SQL anyway. That's not > a general solution, but since you mentioned that the information is in a > string to begin with, that might solve your immediate problem.
That was my first idea indeed. But performance is a big issue, and the proc may need to return 50 lines of 200+chars in a row... (I didn't wrote the specs... ;-) > > > Handling non-scalar arguments is on the TODO list for DBD::Oracle, but it > > > isn't fully ready yet. You might be able to do it with Oracle::OCI, but I > > > haven't used it and can't tell you how. BTW, I'll have a look at Oracle::OCI module... > The func() method isn't a general purpose database interface, it is a means > for DBD drivers to expose specific activities. Run (perldoc DBI and > perldoc DBD::Oracle) to read about func() and the specific private > functions provided by DBD::Oracle. I did before posting. This didn't help me much as the most complete source of info I could ever get about this method is in your post : http://www.geocrawler.com/archives/3/184/1999/4/0/1547753/ I solved my problem using the func() method, along with dbms_output_* stuff. I get back in a perl array the output of $dbh->func(dbms_output_get); and work on it from perl... Anyway, thanks a lot for answering. I've been a perl addict for over 6 years now, and your kindness contributes to make perl such a special language ! Thanks again for your good work. PHleX -- The world is not octal despite DEC.
