RE: Dynamic SQL & DBD::Oracle

From: Koivu, Lisa <Lisa.Koivu_at_Cendant-TRG.com>
Date: Tue, 17 Feb 2004 13:06:58 -0500
Message-ID: <840C139B79E7CC4496B2594E9E35E967046C5375@floexmailbe2.ffci.com>

Hi Mladen,=20

This is in a nutshell what I ended up doing, but not as elegantly as you just did.=20

Thank you.
Lisa

-----Original Message-----
From: Mladen Gogala [mailto:mladen_at_wangtrading.com]=20 Sent: Tuesday, February 17, 2004 12:15 PM To: oracle-l_at_freelists.org
Subject: Re: Dynamic SQL & DBD::Oracle

sub tblcnt {
  my $table=3Dshift;
  return qq{ SELECT count(*) from $table where julian_run_date=3D:RD}; }

my $sth=3D$dbh->prepare(tblcnt("EMP"));

$sth->bind_param(":RD",$RUN_DATE);
$sth->execute;
$sth->bind_column(1,$COUNT);
$sth->fetch();
$sth->finish($WITH_PREJUDICE);

On 02/17/2004 11:01:09 AM, "Koivu, Lisa" wrote:
> Hello everyone,=3D20

>=20

> I can understand why this stmt below doesn't work (invalid table
> name).
> Failure happens in the prepare statement. It also doesn't like
> EXECUTE
> IMMEDIATE.=3D20

>=20

> Can anyone suggest a way around this without hardcoding the table
> name?=3D20

>=20


>     $sql_stmt =3D3D qq{

>                     FROM    ?

>                     WHERE   julian_Run_date =3D3D ?

>                   };

>=20
>=20

> Thank you for any suggestions, comments or website links. =3D20

>=20

> Lisa Koivu
> Data Janitor with No Mop
> Orlando, FL, USA

>=20
>=20
>=20

> "The sender believes that this E-Mail and any attachments were free =20
> of
> =3D
> any virus, worm, Trojan horse, and/or malicious code when sent. This =20
> =3D
> message and its attachments could have been infected during =3D
> transmission. By reading the message and opening any attachments, =20
> the
> =3D
> recipient accepts full responsibility for taking proactive and
> remedial =3D
> action about viruses and other defects. The sender's business entity
> is =3D
> not liable for any loss or damage arising in any way from this =20
> message
> =3D
> or its attachments."

>=20


> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=20

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

"The sender believes that this E-Mail and any attachments were free of =
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission.  By reading the message and opening any attachments, the =
recipient accepts full responsibility for taking proactive and remedial =
action about viruses and other defects. The sender's business entity is =
not liable for any loss or damage arising in any way from this message =
or its attachments."

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 17 2004 - 12:06:58 CST