unable to create stored outline for sql inside a procedure --Resolved

From: Shaleen <shgarg_orafaq_at_hotmail.com>
Date: Tue, 24 Dec 2002 11:13:39 -0800
Message-ID: <F001.00521D8B.20021224111339@fatcity.com>

All,

Oracle support was able to resolve this issue for me and I would like to share the learning. The problem was that I was unable to create stored outline for sql executing within a stored procedure after turning create_stored_outlines=true. Create outlines for sql satetements executing from sqlplus/plsql blocks was not an issue.

The problem is resolved by granting create any outline privilege to the user explicitly.

Once I again I was bit by the limitation of roles not passing privilege within stored procedures and this has to be done explicitly. Why oracle has this limitation beats me!!

Thanks for help Jared & Raj.

Shaleen

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Shaleen
  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). Received on Tue Dec 24 2002 - 13:13:39 CST