--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:49 PM 16-12-02 +0000, you wrote:
> >Hi
> >
> > can anyone tell me how to write a stored Proc using
IBOConsole.
> >when
> >ever I try I get the following error:
> >
> >ISC ERROR CODE:335544569
> >
> >ISC ERROR MESSAGE:
> >Dynamic SQL Error
> >SQL error code = -104
> >Unexpected end of command
> >
> >Statement: create procedure new_procedure
> >as
> >begin
> > suspend
> >
> >
> >even using a simple SP like the one below. Do I need to put it in
> >quotes or
> >some thing
> >
> >
> >create procedure new_procedure
> >as
> >begin
> > suspend;
> >end
>
> Leslie,
>
> Try this:
>
> set term ^;
> create procedure new_procedure
> as
> begin
> suspend;
> end ^
> set term ; ^
>
> The reason?
> For Create procedure, Create Trigger, Recreate Procedure, Alter
Procedure
> and Alter Trigger, you need to set an alternative SQL statement
terminator
> symbol, to enable the parser to accept the semicolon as the
statement
> terminator *within* the module code.
>
> Read up on this is in the isql documentation...
>
> heLen