I use this to alter my sessions:
$dbh->do( q( alter session set nls_date_format = '....' ) );
Should work for the schema as well.
Cheers!
-klm.
----- Original Message -----
From: "Shao, Chunning" <[EMAIL PROTECTED]>
To: "Shao, Chunning" <[EMAIL PROTECTED]>; "Aaron J. Mackey"
<[EMAIL PROTECTED]>; "Tim Bunce" <[EMAIL PROTECTED]>
Cc: "Dean Arnold" <[EMAIL PROTECTED]>; "DBI-users" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 2:23 PM
Subject: Help: how do you alter session in DBI?
Hi, everyone,
In DBI, is there any way we can do something like
"alter session set current_schema=user"?
I need to do it but it does not seem to work.
Thanks
Sorry, i forgot to change the subject in the first message.
Sorry
