The following code snip demonstrates a problem I'm having
$self->{hDB}->do( <<SQL );
SELECT slides_data_sq.nextval FROM Dual
SQL
$self->{hDB}->do( <<SQL );
SELECT slides_data_sq.currval FROM Dual
SQL
DBD::Oracle::db do failed: ORA-08002: sequence SLIDES_DATA_SQ.CURRVAL is not
yet defined in this session (DBD ERROR: OCIStmtExecute) [for statement ``
SELECT slides_data_sq.currval FROM Dual
'']) at SlideOverall.pm line 1500.
You can see I do the steps back to back, why would the second command fail?
PS Autocommit is off...
