RE: Question about bind_param and Oracle

alsalvo_at_sherwin.com
Date: 07/16/04 

To: Timothy.Helck@bowker.com
Date: Fri, 16 Jul 2004 11:53:01 -0400

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

Yes I am logging in as the table owner.
\

"Helck, Timothy" <Timothy.Helck@bowker.com>
07/16/2004 11:54 AM

 
        To: <alsalvo@sherwin.com>, <dbi-users@perl.org>
        cc:
        Subject: RE: Question about bind_param and Oracle

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

-----Original Message-----
From: alsalvo@sherwin.com [mailto:alsalvo@sherwin.com]
Sent: Friday, July 16, 2004 11:45 AM
To: dbi-users@perl.org
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

Relevant Pages

  • RE: Question about bind_param and Oracle
    ... Are you logging on as the owner of the table? ... you need to qualify the table name. ... I'm trying to do the following using Oracle 9i and DBI: ...
    (perl.dbi.users)
  • Re: object reference in stoed proc
    ... If you don't qualify the object sql server will first look for the object ... as such it will eventually try dbo. ... implications by not qualifying the objects with the owner. ... all object refences dbo by default anyway within a stored procedure? ...
    (microsoft.public.sqlserver.security)
  • Re: Functions
    ... > No that is a requirement of a UDF, there is no way around it. ... > should always qualify your objects with the owner anyway, ... such procedure, however, SQL Server will use the one in cache. ... you always use the owner prefix, even if all procedures are owned by dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: create a global procedure
    ... > If you don't qualify by owner you will force more scans of the procedure ... Turn on Profiler and watch for the SP:CacheMiss event, ... > by owner and watch it disappear... ... name (unless they actually reside in another database, ...
    (microsoft.public.sqlserver.programming)
  • Re: change owner of project that is using only generic resources
    ... I am logging in with my own account which has admin priviledges, ... > When you attempt to modify the Owner of the project, ... >> No the project managerassuming ownership have not done this yet, ...
    (microsoft.public.project.pro_and_server)