Re: recovering data rows from PL/SQL scripts

>In article <7n1ont$pri$1_at_nnrp1.deja.com>,
> man_at_sjoki.uta.fi wrote:

> would anyone have a simple example of a PL/SQL script
> (select a,b from foo) and how to get the result (these
> a,b -rows) into a perl array (probably using a fetchrow
> loop).

As I was told this can be almost impossible, since in perl dbi there are apparently no tools to recover anything but scalar arguments from PL/SQL procedures.

However, I was wondering if I could force a PL/SQL procedure to print something to STDOUT?? dbms_output.put_line() does not work, since I can't give a "Set serveroutput on" -command in a perl script (nor in a PL/SQL procedure).

So, simply: how do I force a PL/SQL procedure to print?

Yours,
Marko

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 23 1999 - 09:58:55 CDT