Home » Other » 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: 151
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: 26766
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sat Dec 21 23:11:40 CST 2024