OraFAQ Forum: Server Administration » how to know schema name of a procedure

Home » RDBMS Server » Server Administration » how to know schema name of a procedure

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

how to know schema name of a procedure [message #370037]

Fri, 01 December 2000 15:07

t
Messages: 2
Registered: December 2000

Junior Member

Hi,
with in a stored procedure, i want to know the schema name it belongs to. is there any function to get current schema name or something like that?

thanks,

t

Report message to a moderator

Re: how to know schema name of a procedure [message #370038 is a reply to message #370037]

Mon, 04 December 2000 05:56

Babu Paul
Messages: 38
Registered: November 2000

Member

Hi,

Yes you can, select owner from all_objects where
object_name = upper('procedure name') ;
this would retrive all schema names associated with the procedure.

Good Luck!
Babu

Report message to a moderator

Previous Topic:	Nested Decodes
Next Topic:	SQL Help - translating a select from MS SQL Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 06:55:39 CST 2025