dbTalk Databases Forums  

Oracle ORA-0660

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Oracle ORA-0660 in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mrdjmagnet@aol.com
 
Posts: n/a

Default Oracle ORA-0660 - 01-15-2009 , 12:48 PM






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

Reply With Quote
  #2  
Old   
fitzjarrell@cox.net
 
Posts: n/a

Default Re: Oracle ORA-0660 - 01-15-2009 , 02:12 PM






On Jan 15, 12:48*pm, mrdjmag... (AT) aol (DOT) com wrote:
Quote:
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


Reply With Quote
  #3  
Old   
Shakespeare
 
Posts: n/a

Default Re: Oracle ORA-0660 - 01-15-2009 , 02:27 PM



mrdjmagnet (AT) aol (DOT) com schreef:
Quote:
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.....
Your version of TOAD may be too old.

Shakespeare


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.