Lost Place in temporary table

[Wayne Perry <Wayne.PERRY@EDDEPT.WA.EDU.AU>]

Peggy,

In Oracle, performing certain types of DDL commands such as a 'create table'
forces a COMMIT to occur whether you want it to or not.

I think the cursor which has been opened using your begin-select is getting
closed when the commit is occurring in your 2200- procedure.  Can you create
the table before you start your begin-select and then just insert into it ?

If not, you can try using a PL/SQL block rather than a
begin-select/end-select to read your records as you then have control over
how the initial cursor is established and when the commit points are.


Wayne Perry