The script name is "PMCSExtractEPBWhlseOrders", its a sql script. I am specifying the script in a execute command stage in a sequence. Is this the way I am supposed to do it??
I get a error saying SP2-0640: Not connected, when i do it ... does this mean i dont have the permission to execute the script or , am i doin it wrong?
Please help
Is this the right way to execute a script in a sequence
Moderators: chulett, rschirm, roy
It should mean you left out the connection information. Are we talking Oracle here? Then your script needs to spawn a sqlplus session, supply the logon credentials it needs and then run your sql script. Would be pretty much identical for other databases except for the 'sqlplus' bit.
That's what any 'sql script' needs regardless of the tool launching it.
That's what any 'sql script' needs regardless of the tool launching it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm