Subject running stored proc scripts dynamically
Author maria_ana_ph
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