Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL procedure or package owner ?

PL/SQL procedure or package owner ?

From: Igor V. Podolsky <igoryok_at_soft-review.kiev.ua>
Date: Thu, 13 Jan 2000 13:55:27 +0200
Message-ID: <AAZqRVuy900@soft-review.kiev.ua> 





Hi !



Is there a way to determine a package (or procedure) owner from the package
?


I need to write procedure that works by following way: it should always
return it owner (it scheme name by other words).
There is a built-in 'user' procedure but it returns name of user that called
it, not owner name.


Any suggestions ?



P.S. Duplicate answers to igoryok_at_soft-review.kiev.ua please.



--


Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)



Igor V. Podolsky (igoryok_at_soft-review.kiev.ua)

Received on Thu Jan 13 2000 - 05:55:27 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US