Re: Reduce parse call for stored procedure?

2002-10-23 Thread mkb
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));

Reduce parse call for stored procedure?

2002-10-23 Thread Chuan Zhang
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

Re: Reduce parse call for stored procedure?

2002-10-23 Thread prem
: 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

Re: Reduce parse call for stored procedure?

2002-10-23 Thread chao_ping
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]