Hi all,
Say I have the following:
#!/usr/local/bin/perl
use strict;
my $sql = q{
INSERT INTO REPORT
VALUES (REPORT_NUM_SEQ.NEXTVAL,?,to_date(?,'DD-MON-YYYY HH24:MI')
),
undef, $report, $date_reported
};
Where the report number is incremented via the
REPORT_NUM_SEQ.NEXTVAL statement (REPORT_NUM_SEQ
is an Oracle sequence).
What would be really cool is if you could somehow
get the code to return the value of the incremented
value REPORT_NUM_SEQ.NEXTVAL all within the same
block of code. Is this possible within DBI (v1.20)?
In anticipation,
Stacy Mader....
