Home » RDBMS Server » Server Administration » how to know schema name of a procedure
how to know schema name of a procedure [message #370037] Fri, 01 December 2000 15:07 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 07:36:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.