Re: [SQL] Dynamic SQL Syntax help please

2008-09-04 Thread Ruben Gouveia
thank you Sergio. I decided to use EXECUTE v_stmt into v_total_pop; On Thu, Sep 4, 2008 at 2:00 PM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>wrote: > On Thu, 4 Sep 2008 13:41:16 -0700 > "Ruben Gouveia" <[EMAIL PROTECTED]> wrote: > > > I created a simple function that i want to use another func

Re: [SQL] Dynamic SQL Syntax help please

2008-09-04 Thread Ivan Sergio Borgonovo
On Thu, 4 Sep 2008 13:41:16 -0700 "Ruben Gouveia" <[EMAIL PROTECTED]> wrote: > I created a simple function that i want to use another function > (in the same schema) that will be used to create a sql statement. > I get the following error when i try this: > > *ERROR: syntax error at or near "EXE

[SQL] Dynamic SQL Syntax help please

2008-09-04 Thread Ruben Gouveia
I created a simple function that i want to use another function (in the same schema) that will be used to create a sql statement. I get the following error when i try this: *ERROR: syntax error at or near "EXEC" at character 1 QUERY: EXEC SQL EXECUTE $1 INTO $2 CONTEXT: SQL statement in PL/P