At 06:08 PM 31-08-02 +1200, you wrote:

>Hello IBO support
>
>Using D6 and IBO 4.2Hi.
>I am using a TIB_DSQL to execute small scripts.
>
>The following executes correctly:
>
>ALTER PROCEDURE HELLO (INTEXT VARCHAR(7))
>returns (OUT VARCHAR(7))
>AS
>begin
> out = 'hello';
> exit;
>end
>
>whereas the following produces the error message
>"Unsupported Column type :0"
>
>ALTER PROCEDURE HELLO (INTEXT VARCHAR(7))
>returns (OUT VARCHAR(7))
>AS
>begin
> out = :intext;
> exit;
>end
>
>Any suggestions?

It's off-topic for IBO, but...

I just created it in a dialect 3 database using your exact code and it
compiles and works fine.

When I do
EXECUTE PROCEDURE HELLO('Basil') it returns 'Basil' in the Fields[] array.

Under what conditions do you get the error message?

Helen