Re: sql with bind variable in stored procedure doesnt use

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 deleting the statistics for that particular table and I am never going to analyze that table again.

Thanks
Shaleen
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, December 13, 2002 12:14 PM

> 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 is version dependent, then Oracle will brand this a 'feature'
rather
> than a bug. And I think I know why this is happening.... As per the
Concepts
> manual, "When you create a stored procedure, Oracle parses the procedure
and
> stores its parsed representation in the database." I assume that when this
> SP is called, the SQL segment is reconstructed by the kernel and it looses
> its formatting during this reconstruction, thus creating a different
> signature/hash area. 9iR2 may be reconstructing this properly while 8i may
> not (as it was the first release for Outlines).
>
> I hope this make sense! Anyone willing to look at and compare the
structures
> of IDL_UB1$ and IDL_UB2$ and IDL_SB4$ tables (SYS) between the two
versions.
> (Don't have my hands on 9iR2 yet - I am way behind the times here :(
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> So WHO is the Reason for the Season?! Write me for details!
>
> ** The opinions and statements above are entirely my own and not those of
my
> employer or clients **
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaleen Garg
  INET: shgarg_orafaq_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).