OraFAQ Forum: SQL & PL/SQL » How can I see the object which is using some other object?

Home » SQL & PL/SQL » SQL & PL/SQL » How can I see the object which is using some other object?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I see the object which is using some other object? [message #23490]

Thu, 12 December 2002 14:54

Tajeev
Messages: 5
Registered: December 2002

Junior Member

I have a function called "mydate". When I tried to write another function with the same name it gave me the following error message:
"ERROR at line 1:
ORA-00955: name is already used by an existing object"

How can I see which object use the function mydate?

Report message to a moderator

Re: How can I see the object which is using some other object? [message #23491 is a reply to message #23490]

Thu, 12 December 2002 16:17

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You can only have one object named MYDATE. If you have a function MYDATE, you cannot create a procedure/function/table/anything named MYDATE. If you are just trying to update the existing MYDATE function, be sure to use the CREATE OR REPLACE syntax instead of just CREATE.

Report message to a moderator

Previous Topic:	Create table with date constraint
Next Topic:	How to Query a cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 23:23:38 CDT 2024