RE: :Proxy::st execute failed: CallMethod: Can't bind unknown pla ceholder

From: David Claughton (david.claughton_at_IntechSolutions.co.uk)
Date: 12/16/03 

To: "'murali@epiphany.com'" <murali@epiphany.com>, dbi-users@perl.org
Date: Tue, 16 Dec 2003 09:45:11 -0000

Murali,

You are calling 'execute' with the parameter $bfn, which instructs DBI/SQL
Server to replace the first placeholder in the SQL statement with the value
of $bfn. However there are no placeholders in the SQL statement to replace!

(Your use of $bfn in the SQL Statement is not a placeholder - the value in
simply substituted by perl prior to the 'prepare' being performed - as would
be the case with any other string).

Either call 'execute' with no parameters for a one-off prepare and execute,
or if you want to use the placeholder replace $bfn in the SQL statement with
a single question mark ( ? ).

Hope this helps,

David.

-----Original Message-----
From: murali@epiphany.com [mailto:murali@epiphany.com]
Sent: 15 December 2003 22:12
To: dbi-users@perl.org
Subject: DBD::Proxy::st execute failed: CallMethod: Can't bind unknown
placeholder

Greetings!!

We are using ActivePerl 5.6.1 (Build 635) & DBI (1.27) Proxy running on
MS Windows to connect
to SQL Server from Solaris.

Even though the following SQL query succeeds in MS SQL Query Analyzer,
Via DBI Proxy the
following query returns an error:

        my $sth = $dbh->prepare( "select lkpver.text_string as
version,lkpst.text_string as
        status from release_target rt, lookup lkpst, lookup lkpver where
rt.product_issue_id
        = $bfn and lkpst.lookup_category_name =
'm2_release_target_status' and lkpst.code_int
        = rt.status_lkp and lkpver.lookup_category_name = 'm2_fix_in'
and lkpver.code_int =
        rt.fix_in_version_lkp");

        $sth->execute($bfn);

The Error Message:

        DBD::Proxy::st execute failed: Server returned error: Failed to
execute method
        CallMethod: Can't bind unknown placeholder '1' at
E:/netperl/site/lib/DBI/ProxyServer.pm line 313.
        exec: DBI::st=HASH(0x41f870)

Any Pointers, Help to resolve this issue would be very much appreciated.

Thanks,
-Murali
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its
contents copied or disclosed to, persons other than the intended
recipient. However, the contents of this e-mail may be intercepted,
monitored or recorded by Insurance Technology Solutions Limited for
the purposes of ensuring compliance with its policies and procedures.
Any liability (in negligence or otherwise) arising from any third party
acting, or refraining from acting, on any information contained in this
e-mail is excluded.

Any views expressed in this message are those of the individual
sender and do not necessarily represent the views of
Insurance Technology Solutions Limited.

If you have received this e-mail in error please notify the
originator of the message.

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with
virus detection software.

Relevant Pages

  • Re: tkprof interpreatation question
    ... library cache--Hard parse) ... Misses in library cache during execute (Misses while about to execute ... closes a cursor and then reopened a cursor with the same SQL statement ...
    (comp.databases.oracle.server)
  • Re: Optimizing inline view
    ... Mike C wrote: ... Can you verify that the SQL statement that ... I updated the statistics on this table and the thing ... If you are still having problems, execute the three ALTER SESSION ...
    (comp.databases.oracle.misc)
  • Re: newbie, getting cost plan
    ... I want to get the -real- cost and plan of an sql statement, ... assume that you can execute the SQL statement in question in SQL*Plus, ... However, be aware that this dilutes the information in the trace file, ...
    (comp.databases.oracle.server)
  • Re: dbs.Execute strSQL error - Too few parameters
    ... executing an update SQL statement in VBA. ... SQL executed with Execute goes straight to Jet without the advantage of the ... What is easier though is to delimit the statement so that the form reference ...
    (comp.databases.ms-access)
  • Re: dbs.Execute strSQL error - Too few parameters
    ... executing an update SQL statement in VBA. ... SQL executed with Execute goes straight to Jet without the advantage of the ... What is easier though is to delimit the statement so that the form reference ...
    (comp.databases.ms-access)
Quantcast