Re: Change default schema

From: Paul Brewer <paulb_at_pbrewer.demon.co.uk>
Date: 1997/10/21
Message-ID: <YJtnzNAkCRT0Ewic@pbrewer.demon.co.uk>#1/1

In article <3444A186.7B11_at_dokpro.uio.no>, =?iso-8859- 1?q?Lars_J=F8rgen_Tvedt?= <ljt_at_dokpro.uio.no> writes
>Is there a way to alter the default schema/namespace in a
>user session? I want Oracle to default search for an object in
>another users schema, and not in the schema of the current user.
Try: 'Alter session set current_schema = xxx' from within your forms application. It works for us.
Paul Brewer Received on Tue Oct 21 1997 - 00:00:00 CDT