Subject Re: [firebird-support] SQL Error when writing basic procedure in IBO Console.
Author Helen Borrie
At 11:52 PM 20/12/2005 +0000, you wrote:
>The procedure is created with IBO Console.
>Input variable is a type Interger.
>Output variable is b type Integer.
>
>Code of the procedure is:
>
>begin
>b = a;
>end
>
>
>Here is the error I just dont understand why this happens:
>
>ISC ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -206
>Column unknown
>A
>At line 6, column 5.

It's not legal PSQL. You have to have a procedure header and declare
variables, either as procedure arguments or local variables. So, e.g.

create procedure duh (b integer)
returns (a integer)
as
begin
a = b;
/* and for this to make any sense */
suspend;
end

Another one:

create procedure duh1
returns (a integer)
as
declare variable b integer = 99;
begin
a = b;
suspend;
end

Have you read the LangRef.pdf at all?

./heLen