Toad World® Forums

stored procedure from automation script

Hi,

I am having trouble using the execute script function within the automation tool when calling a stored procedure. My script is:

BEGIN

UHC_SP;
END;

The job fails with the following error:

Timestamp Message
9/16/2011 9:26:47 AM Script execution complete
9/16/2011 9:26:47 AM Executing script: BEGIN
DW.UHC_NEXT_LOT_SP ();
END
9/16/2011 9:26:47 AM Execution Error: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

;
The symbol “;” was substituted for “end-of-file” to continue.
9/16/2011 9:26:47 AM Execution SQL: BEGIN
DW.UHC_NEXT_LOT_SP ();
END
9/16/2011 9:26:47 AM Executing rollback
9/16/2011 9:26:47 AM Terminating execution due to error. To continue, change On Error value to continue after error.
9/16/2011 9:26:47 AM at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Quest.Toad.Util.Global.Invoke(Delegate handler, Object[] args)
at Quest.Toad.Db.ScriptEngine.PostProcessOne(CommandResult result, Object data)
at Quest.Toad.Db.ScriptEngine.InternalCommandExecuted(CommandResult result, IDbConnection localConnection)
at Quest.Toad.Db.ScriptEngine.ExecuteScript(Boolean oneStatement, String sql, Object[] param)
at Quest.Toad.Db.ScriptEngine.ExecuteScript(String sql, Object[] param)
at Quest.Toad.Workflow.Activities.Database.SelectDataActivity.Execute(ActivityExecutionContext executionContext)
9/16/2011 9:26:47 AM Failed

I can prodcue the same error in TDA 2.7. I tested this in TDA 3.0 and do not get this error. TDA 3.0 is being released next Tuesday so I would upgrade to that release. The Beta is available now if you want to test the fix.

Debbie