Subject | running stored proc scripts dynamically |
---|---|
Author | maria_ana_ph |
Post date | 2002-08-13T15:10:02Z |
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
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