dinamicaly create a stores procedure

[crebegea]

Hi,

I need help please in this situation.
I'm using Delphi, Firebird over bde (that means ttable and tquery
components). In my shrink-wrapped apps I got the habit of updating the
DB structure from delphi code. It all worked wonderfully except one
thing. I can't seem to be able to create a (more complex) stored
procedure from code. I mean:

query1.sql.add('create procedure proc_name (var1 integer)
returns (ret1, ret2)
as
begin

/*this is where it starts*/
for
select * from tblTable
into :ret1, :ret2
do suspend;
end
');

This is it. All is right if a do it from Firebird (or ibexpert better
say - never mind other eventual syntatical mistakes ) but when I
execute the query from Delphi with query.execsql;

I get 'illegal character ?' at the position of ':'.

In short, I can't create an SP that has the character ':'. I guess it
only expects ':' to mark a parameter in a parameterized query.
Can any of you find a way around this?

joyfully, cornel.