Subject Re: running stored proc scripts dynamically
Author maria_ana_ph
ha!ha! got it.

just set ZIbSqlStoredProc1.ParamCheck to FALSE..

as in ZIbSqlStoredProc1.ParamCheck := FALSE.

--- In ib-support@y..., "maria_ana_ph" <maria_ana_ph@y...> wrote:
> hi!
>
> i'm using zeos stored proc components.
> I want to create copies of the database dynamically using the
script
> generated from the original database.
>
> The problem occurs during the 'ALTER PROCEDURE' part where I have
> output parameters and local variables. These are interpreted by the
> zeos components as query parameters.
>
> The script looks like this:
>
>
> Create procedure ProcX
> returns
> (
> X : datatype
> )
> begin
> exit;
> end;
>
> alter procedure ProcX
> returns
> (
> X : datatype
> )
> as
> begin
> select statement
> into :X
> end;
>
>
>
> any ideas?
>
>
> thanks very much!
> Maria