04-11-2013 07:51 PM
I am trying to write a program which connects to oracle to extract sequence object and storing it into a variable.
How can I modify my sql pass through statement so that it runs only once ? My requirement is that first time i run eg project, i need to run the pass through and next time when i run the project, I need to have the value which i retained first...
Can anyone help me out with this?
04-12-2013 04:08 AM
The simplest would be to split into two projects - one for your one time job, and store it's results in permanent location.
And the next project will read from that.