Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to drop procedure

Jaroslaw BiczOct 29 2013 — edited Nov 15 2013

Hi

while i'm  issuing drop procedure  generatePasswordForEportalUser   i have an error ORA-00600:  [kqlobjlod-no-result-from-proc$], [1403], [659858], [], [], [], [], [], [], [], [], [].

i found on metalink then  Doc ID 1267554.1   is about this error i'm using oracle 11.2.0.3  in this document there is an info that 11.2.0.2  solves the issue 

Interesting thing is that select * from user_procedures where upper(object_name) like  upper ('generatePasswordForEportalUser');

generatePasswordForEportalUser6598581PROCEDURENONONONONODEFINER

object name is in lovercase it was created by create procedure generatePasswordForEportalUser  as

begin

null;

end ;

without " name "   why it is in lowercase in data dictionary

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2013
Added on Oct 29 2013
1 comment
579 views