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." ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------