Executing pass through only once in a project

[Sheeba]

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?

[LinusH]

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.

[Sheeba]

Thanks Linush... I will try that....Since it is oracle sequence number, I want that to be created for each project.