Subject | Re: [firebird-support] SQL Error when writing basic procedure in IBO Console. |
---|---|
Author | Helen Borrie |
Post date | 2005-12-21T00:24:08Z |
At 11:52 PM 20/12/2005 +0000, you wrote:
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
>The procedure is created with IBO Console.It's not legal PSQL. You have to have a procedure header and declare
>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.
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