Re: Oracle ORA-0660

From: fitzjarrell_at_cox.net <oratune_at_msn.com>
Date: Thu, 15 Jan 2009 12:12:12 -0800 (PST)
Message-ID: <46fa2262-fde8-444b-bafa-7132eceefdae_at_u14g2000yqg.googlegroups.com>


On Jan 15, 12:48 pm, mrdjmag..._at_aol.com wrote:
> Has anyone ever used the program TOAD?  I'm using it to debug a
> procedure written by one of our guys here.  The procedure small, only
> 88 lines.
>
> I've never had this problem before, but everytime I try and execute it
> I get an error that says 'Object Must Be Declared'.  I granted DBA
> access to this use and no go.
>
> It works fine if I execute it from SQLPLUS......so, I'm missing
> something.  Any suggestions?  I can post the code if it would help.....

Post the actual error number, as ORA-0660 isn't valid. Also are you using the same user account from TOAD as you are from SQL*Plus?

David Fitzjarrell Received on Thu Jan 15 2009 - 21:12:12 CET

Original text of this message