| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Dynamic SQL & DBD::Oracle
Hello everyone,=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.=20 Can anyone suggest a way around this without hardcoding the table name?=20
$sql_stmt =3D qq{ SELECT count(*)
FROM ?
WHERE julian_Run_date =3D ?
};
Thank you for any suggestions, comments or website links. =20
Lisa Koivu
Data Janitor with No Mop
Orlando, FL, USA
"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."
 |
 |