How about using bind variables in your execute
immediate statement.
Please see doc id 34433.1 and 366753.999 on Metalink
as I followed 34433.1 for what I tested below.
366753.999 is a forum question which relates very well
to doc id 34433.1.
create table t (col1 number, col2 varchar2(10));
Hi, DBA Guru,
I have a stored procedure of a package which is called with execute immediate in
a loop with runtime input parameters. I found that no. of parse calls(451983) is
equal to no. of executions (451982). Is there any way such as set
cursor_sharing=force or keep this stored
:
Subject:Reduce parse call for stored procedure?
Hi, DBA Guru,
I have a stored procedure of a package which is called with execute immediate in a loop with runtime input parameters. I found that no. of parse calls(451983) is equal to no. of executions (451982). Is there any way
Chuan Zhang,
Since you are using execute immediate, you use dynamic sql.
If you want to reduce the parse, can u try not using the dynamic sql?
Keep it won't help at all.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]