Re: Insert into table from different schemas

From: <shelbyko_at_my-dejanews.com>
Date: Thu, 06 May 1999 20:52:16 GMT
Message-ID: <7gsvdu$jnc$1@nnrp1.deja.com>

One possible solution is to use dbms_sql to create the insert statement dynamically. You can qualify the tablename with the schema name by getting the current username (select user from dual).

In article <37317f28.0_at_pink.one.net.au>, "Mark Dexter Santos" <mdsantos_at_one.net.au> wrote:
>
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 15:52:16 CDT