any difference in term of performance

Hi

I came across this code inside a stored procedure written by one of our developers.

----start----
sql_stmt := 'select t.column_one, t.column_two
             from my_table t
             where t.column_pk = :1';

execute immediate sql_stmt
into tmpC1, tmpC2
using varPK;

----end-----

I would normally just write it as:

----start----
select t.column_one, t.column_two
into tmpC1, tmpC2
from my_table t
where t.column_pk = varPK;

----end-----

Is there any difference in term of performance for the 2 methods above?
If yes, which is faster and why?

regards
Daud

---------------------------
Oracle 8.1.7.4 on HPUX 11.0
---------------------------
Received on Mon Mar 22 2004 - 06:44:24 CST