Are you logging on as the owner of the table? If not, you need to qualify the table 
name.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 16, 2004 11:45 AM
To: [EMAIL PROTECTED]
Subject: Question about bind_param and Oracle


Hi all,

Hoping someone can help me out here.

I'm trying to do the following using Oracle 9i and DBI:

$table_name = "USERS";

$sql = "SELECT COUNT(*) FROM ?";

$sth = $dbh->prepare($sql);

$sth->bind_param(1,$table_name);

$sth->execute;
.
.
.
However, I'm getting an error about an invalid table name (I have verified 
that the table is valid and that I spelled it correctly). 

Is this even possible with Oracle and DBI?

Please let me know.

Thanks.

Aaron Salvo

Reply via email to