Workflow Soluiton

Hi.

Is it possible to enter multiple commands into an SQL integration?

Our environment is designed so, that when I run the first command, it sets the range of what I'm allowed to see in the database. Then the second query returns only data that is within the boundaries of that range. Sort of creating a temporary dmz inside the database.

And it works, when run from Oracle's command line tool, but when I compile it as an integration, it gives errors such as ORA-00911: Invalid character. Both commands work separately, but I need to run them in the same session, because if I execute two separate queries, they are two different sessions. If  the function is not executed before the query in the same session, it returns zero rows.

Regards,
Mike

I definitely know you can do multiple commands at once via the Query/Script generator. I've done it several times myself against a SQL database.

Just guessing here.... try it without the semicolon. Or try using @parameter name vs. :parametername.

Have you tried putting a checkmark in the box under the Query window, where it says:

"Execute queries separated, splitting by this character"

And putting ; in the box after ???

Just came back to say that obvious tip was obvious and indeed the separation character was the key.