PDA

View Full Version : Install Anywhere 2014 : SQL script issue



abhinavw
11-21-2014, 12:15 AM
I am using InstallAnywhere 2014.
I have created an installer for my application.
I have a requirement in which I want to run a script over oracle database.
Everything inside the script works fine except the procedures. After running the scirpt through run script action target database shows that procedures gets compiled but not executed.
The script works fine when executed through sql developer but gives issue when used in installerthe log file shows error as" sql statement not properly ended.

example:

CREATE PROCEDURE MY_PROCEDURE
..
..
..

( this works fine.)
/
EXECUTE MY_PROCEDURE; ( this is where i am facing problem. this sql command does not work :confused:)
/

Please help ! Thanks in advance !!