I've got an application with a sequence, trigger (before insert that uses this sequence) and a function that calls the currval of this sequence.
When I run the app Oracle gives this error:
ORA-08002: sequence TEST_SEQ2.CURRVAL is not yet defined in this session
So, I removed the function and ran the app, inserted data and closed the app.
Then I added the function again.
When I then run the app everything works properly.
Does anybody know how I can define this currval before opening the app.
Thanks
When I run the app Oracle gives this error:
ORA-08002: sequence TEST_SEQ2.CURRVAL is not yet defined in this session
So, I removed the function and ran the app, inserted data and closed the app.
Then I added the function again.
When I then run the app everything works properly.
Does anybody know how I can define this currval before opening the app.
Thanks