Speed between ODBC and Embbded SQL

Hello,

[Quoted] I am asking why à Embdded SQL Code (Proc) are very fast and the same query [Quoted] in ODBC are so slow ?

The query recive by oracle are :

For ODBC :

SELECT agent.pwd

    FROM agent
    WHERE upper(agent.mnemo)='TSX'

For Embdded SQL :

SELECT agent.pwd

    INTO :b0
    FROM agent
    WHERE upper(agent.mnemo)=:b1

Thanks
LeguMan Received on Sat May 12 2001 - 10:26:36 CEST