Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_metadata.get_ddl Error

RE: dbms_metadata.get_ddl Error

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Mon, 15 Oct 2007 11:47:23 -0400
Message-ID: <21469B88E0EA11498818517F21033531DEF586@EPRI17P32001A.csfb.cs-group.com>


The procedure owner needs the relevant privileges granted directly, not via a role.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Ebadi Sent: Monday, October 15, 2007 11:31 AM
To: Ghassan Salem
Cc: oracle-l_at_freelists.org
Subject: Re: dbms_metadata.get_ddl Error

Here is the exact call and the user calling this procedure has DBA as well as the procedure owner:  

select dbms_metadata.get_ddl('INDEX','MY_TAB_IDX5','OPS$ORACLE') into v_index_info from dual;  

The ironic thing is a similar select works just fine from SQLPLUS, but inside the procedure it fails with ORA-31603.  

Thanks,
Abdul

Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

        How are you calling dbms_metadata.get_ddl (i.e. are you passing the correct schema to it)?

        second, the calling user does have the rights to do this on the index's schema?         

        rgds                  

        On 10/15/07, A Ebadi <ebadi01_at_yahoo.com> wrote:

                We have a procedure which calls dbms_metadata.get_ddl to get the ddl for an index & this works fine for objects (indexes) owned by the same user as my procedure. For all other objects I get the error below. I have an SR open with Oracle for several days now, but no solution has been given. Any advise would be appreciated.                  

                Environment: Oracle 10.2.0.3.0 on Sun Solaris 2.10.                  

		Here is the error:
		ORA-31603: object "MY_TAB_IDX5" of type INDEX not found
in schema "OPS$ORACLE"                  
		Thanks,
		Abdul
		

________________________________
Be a better Heartthrob. Get better relationship answers
<http://us.rd.yahoo.com/evt=48255/*http://answers.yahoo.com/dir/_ylc=X3o DMTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTkl fMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545433> from someone who knows.

                Yahoo! Answers - Check it out.


Be a better Globetrotter. Get better travel answers <http://us.rd.yahoo.com/evt=48254/*http://answers.yahoo.com/dir/_ylc=X3o DMTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTkl fMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545469> from someone who knows.
Yahoo! Answers - Check it out.



Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 15 2007 - 10:47:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US