The bug number is 2398050. You can read about it in metalink alongwith the
workaround. It is fixed in 9i. But the problem is that even workaround does
not work for me. I am working with oracle support on this.
Meanwhile I have resolved my basic problem with AQ for which I was trying
all this by de
John,
Shaleen mentioned to me, in a direct e-mail, that there was a bug in 8i and there was
some workaround available. I do not have the bug number.
- Kirti
-Original Message-
Sent: Friday, December 13, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
Shaleen/Kirti,
If this
6:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: sql with bind variable in stored procedure doesnt use
>
>
> It appears to be version dependent...
>
> Here is what I did in 9i R2 (and in 9i R1):
>
> SQL> create table emp (num number,sal numbe
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,
>
>
It appears to be version dependent...
Here is what I did in 9i R2 (and in 9i R1):
SQL> create table emp (num number,sal number);
Table created.
SQL> insert into emp values(1,1);
1 row created.
SQL> create or replace procedure t as
2 total number:=0;
3 cursor c1 is
4 select sal from em
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
I tried this even without bind variable and could
not make it work from a stored procedure. ANy help over here will be very
appreciated
Folllowing is the testcase.
Thanks
Shaleen
create table emp (num number,sal number);insert
into emp values(1,1); create or replace procedure t astotal
n