Home » SQL & PL/SQL » Client Tools » script cutting off (Developer 6i, Databse 11G R2,window 7 ultimate)
script cutting off [message #634134] Wed, 04 March 2015 14:04 Go to next message
kilimanjaro
Messages: 134
Registered: May 2009
Location: Tanzania
Senior Member
Hello Buddies

When running setup scripts,@myscripts......, it reaches a point when the script cuts off from installing without finishing. Is there a specific setting of which the whole script can be executed without cutting off at a certain point ?.

Thank you.
Re: script cutting off [message #634135 is a reply to message #634134] Wed, 04 March 2015 14:09 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
We can not debug code we can not see.
Each "sql" file should contain "EXIT" as the last line.
Re: script cutting off [message #634147 is a reply to message #634134] Wed, 04 March 2015 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post your script and its execution.

icon10.gif  Re: script cutting off [message #635942 is a reply to message #634134] Mon, 13 April 2015 09:25 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
If you are sequentially executing a set of scripts, make sure the intermediate scripts DO NOT end with "EXIT" command, otherwise the execution will end at that point.
PS: set echo on and spool the results from the execution to make sure there are no errors which also would end the process.
Cool

[Updated on: Mon, 13 April 2015 09:28]

Report message to a moderator

Previous Topic: SQL Developer - access to AS400 iSeries
Next Topic: Passing parameter to a SQLPLUS script
Goto Forum:
  


Current Time: Wed Feb 21 00:02:14 CST 2018

Total time taken to generate the page: 0.01130 seconds