or clients **
> -Original Message-
> From: Shaleen Garg [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 12, 2002 2:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: sql with bind variable in stored procedure doesnt use
> stored
>
>
> John,
>
>
John,
Thanks for the input. As far as I can see that sql's are exactly same in my
example. Morover none of the initialization parameters have been changed.
Need input from all Gurus
Thanks
Shaleen
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Th
Shaleen,
I have not been able to dig deeper (yet) into this. However the following
_may_ be why this is not working: I believe that the stored outline is
matched with an about-to-be-executed SQL using the Hash value of the SQL.
The hash value is computed by some mumbo-jumbo based on the actual SQ
y, December 11, 2002 2:08
PM
Subject: sql with bind variable in stored
procedure doesnt use stored outlines
All,
I am unable to make stored outlines work for sql
statements with bind variable in stored procedures. Please see following
sample code and tell me what am I doing
All,
I am unable to make stored outlines work for sql
statements with bind variable in stored procedures. Please see following sample
code and tell me what am I doing wrong.
Thanks in Advance
create table emp (num number,sal number);insert
into emp values(1,1); create or replace procedu