firebird-docs

[Firebird-docs] SP using IBOConsole - newbie

[Leslie <no-...@an...>]

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


Many thanks

 Leslie

Re: [Firebird-docs] SP using IBOConsole - newbie

[Helen B. <he...@tp...>]

This is not a support list.  Please send your question to ib-support - join 
at http://www.yahoogroups.com/community/ib-support

Helen
Mail admin

At 11:05 AM 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
>
>
>Many thanks
>
>  Leslie
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:
>With Great Power, Comes Great Responsibility
>Learn to use your power at OSDN's High Performance Computing Channel
>http://hpc.devchannel.org/
>_______________________________________________
>Firebird-docs mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-docs