If you have Oracle 8 (I missed the start of this thread, so I don't know
what you're using, sorry), you can use a RETURNING clause with an UPDATE.
Something like this (untested):
> #!/usr/local/bin/perl
> use strict;
>
> my $sql = q{ INSERT INTO REPORT
VALUES (REPORT_NUM
I may be wrong here, but I don't think DBD::Oracle can cope with PL/SQL
tables or VARRAYs.
Go with REF cursors.
There are examples of passing back cursors from a PL/SQL block in the
DBD:Oracle docs. The principle is the same for REF cursors returned from a
stored procedure. Here's a quick examp
> I use reference cursor parameters for this in Oracle.
>
> If the query results come from a single select within the procedure, your
> PL/SQL guys can define a reference cursor for the select and pass you that
> in an IN/OUT parameter. There are examples of how to treat this parameter
> as a DB
