RE: sql with bind variable in stored procedure doesnt use

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).