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 -> Insert into table from different schemas

Insert into table from different schemas

From: Mark Dexter Santos <mdsantos_at_one.net.au>
Date: Thu, 6 May 1999 21:42:25 +1000
Message-ID: <37317f28.0@pink.one.net.au>

Hi all,

Just a question from an oracle novice:

How can I write a stored procedure in schema X which can insert data into the current user's schema???
That way for different users, they can run the same procedure but it writes to their own private table

Thanks in advance

Mark Received on Thu May 06 1999 - 06:42:25 CDT

Original text of this message

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