1 Replies - 1257 Views - Last Post: 03 September 2014 - 12:23 AM

#1 kayyos  Icon User is offline

  • New D.I.C Head

Reputation: 6
  • View blog
  • Posts: 27
  • Joined: 22-October 13

PL/SQL Unsure what is the cause of this error?

Posted 02 September 2014 - 10:05 PM

This is my stored function.

create or replace FUNCTION DELETE_SALE_FROM_DB RETURN number AS
  saleIdToDelete number;

BEGIN

  Select MIN(saleId) INTO saleIdToDelete FROM SALE; 
  return saleIdToDelete;
  
EXCEPTION

  WHEN OTHERS THEN 
   dbms_output.put_line(sqlerrm);  
END;




This is the error i am receiving

Error report -
ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:


I am sure its just something dumb I cannot see, however it is really making me agitated!

Also, sorry if this is not enough info, I have no idea where the error comes form so I was unsure what info to share.


p.s I understand this function is pointless and dumb its for an assignment :P/>

Is This A Good Question/Topic? 0
  • +

Replies To: PL/SQL Unsure what is the cause of this error?

#2 x-logan  Icon User is offline

  • D.I.C Head

Reputation: 15
  • View blog
  • Posts: 88
  • Joined: 18-April 13

Re: PL/SQL Unsure what is the cause of this error?

Posted 03 September 2014 - 12:23 AM

try changing name of your procedure... as there might be a function with same name
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1