On 2011-09-10, Gabriel Filipiak wrote:
> --bcaec517adbceea3c804ac90a376
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi, this is my first on this list.
>
> I want to know the basics of dynamic sql especially in PostgreSQL. I was
> googling for a while but have no luck for getting a good desc
Hi, this is my first on this list.
I want to know the basics of dynamic sql especially in PostgreSQL. I was
googling for a while but have no luck for getting a good described examples.
Maybe someone here could give me some links to the materials from which you
where studying this subject.
Ok so t
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
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
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
On Mar 20, 2008, at 5:28 PM, Erik Jones wrote:
Hi, I've been working on a generic date partitioning system and I
think I've reached something that can't be done, but I thought I'd
post a question to the masses in the hope that I'm missing
something. The basic idea of what I'm doing is som
Hi, I've been working on a generic date partitioning system and I
think I've reached something that can't be done, but I thought I'd
post a question to the masses in the hope that I'm missing something.
The basic idea of what I'm doing is some userland scripts that will
accept a table name
Gabriel Adolfo Sirni <[EMAIL PROTECTED]> writes:
> Procedure pr_prueba(param in varchar2) is
> v_name varchar2(50);
> BEGIN
> EXECUTE IMMEDIATE ' Begin pr_out_area_code(:1,:2);
> End; ' USING param, OUT v_name;
> END;
You're asking the wrong people; this is not an Oracle mailing list.
Error using the command EXECUTE IMMEDIATE with an OUT
parameter
Example: I have this procedure pr_prueba, who call
other procedure "pr_out_area_code" using the command
execute immediate, who has an IN paramter and an OUT
paramter.
Procedure pr_prueba(param in varchar2) is
v_name varchar2(50);
BEG
>
> I am able to find couple
> of examples for dynamic sql programming through ecpg. But i want to
> do dynamic sql programming through libpq.
> If anyone has programs doing the dynamic sql programmming using the
> libpq libraries please mail to me.
>
Attached you'll find my encapsulated library of
Hi,
I am new to the embeeded sql programming. I am able to find couple
of example for dynamic sql programming through ecpg. But i want to
do dynamic sql programming through libpq.
If anyone has program doing the dynamic sql programmming using the
libpq libraries please mail to me.Even pointers o
Hi,
Is it possible to execute a dynamic sql query in pl/pgsql like
the oracle feature for PL/SQL: EXECUTE IMMEDIATE 'UPDATE my_table SET
col1=val1 ';
Thanks.
_
Get Your Private, Free E-mail from MSN Hotmail at http://ww
12 matches
Mail list logo
