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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Beginner: Procedure Help

Re: Beginner: Procedure Help

From: JoeZ53 <joez53_at_aol.com>
Date: 26 Jan 1999 19:45:41 GMT
Message-ID: <19990126144541.22199.00004113@ng-fi1.aol.com>


One word of caution when using USER_ tables: The view that you will access will be based on the owner of the procedure. i.e. If the user SCOTT owns the procedure, the results will be for user SCOTT only. If you want this procedure to be universal, use DBA_ tables where owner = user. Received on Tue Jan 26 1999 - 13:45:41 CST

Original text of this message

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