Hi,
Use dynamic SQL (execute imediate).
Also, consider placing your code into a stored proc
called by the trigger.
- "George Leonard (ZA)"
<George.Leonard_at_za.didata.com> a écrit : > Hi guys
>
> I am trying to create the following trigger.
>
> The user in question is logging in using siebel
> application and siebel does
> not allow multiple SQL statements during login so we
> through this might
> solve the problem. My problem now is though, the set
> rollback works but the
> alter session statements does not seem to want to
> work.
>
> The server needs to be in RBO since this is the only
> mode supported by
> siebel.
>
> Help appreciated.
>
> create or replace trigger smload.logon after logon
> on database
> begin
> SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
> Alter session enable parallel query;
> Alter session set SORT_AREA_SIZE = 10485760;
> Alter session set OPTIMIZER_MODE = choose;
> end;
> /
>
> George
> ________________________________________________
> George Leonard
> Oracle Database Administrator
> Dimension Data (Pty) Ltd
> (Reg. No. 1987/006597/07)
> Tel: (+27 11) 575 0573
> Fax: (+27 11) 576 0573
> E-mail:george.leonard_at_za.didata.com
> Web: http://www.didata.co.za
>
> You Have The Obligation to Inform One Honestly of
> the risk, And As a Person
> You Are Committed to Educate Yourself to the Total
> Risk In Any Activity!
> Once Informed & Totally Aware of the Risk, Every
> Fool Has the Right to Kill
> or Injure Themselves as They See Fit!
>
>
>
>
>
> This message contains information intended solely
> for the addressee,
> which is confidential or private in nature and
> subject to legal privilege.
> If you are not the intended recipient, you may not
> peruse, use,
> disseminate, distribute or copy this message or any
> file attached to this
> message. Any such unauthorised use is prohibited and
> may be unlawful. If
> you have received this message in error, please
> notify the sender
> immediately by e-mail, facsimile or telephone and
> thereafter delete the
> original message from your machine.
>
> Furthermore, the information contained in this
> message, and any
> attachments thereto, is for information purposes
> only and may contain the
> personal views and opinions of the author, which are
> not necessarily the
> views and opinions of Dimension Data (South Africa)
> (Proprietary) Limited
> or its subsidiaries and associated companies
> ("Dimension Data"). Dimension
> Data therefore does not accept liability for any
> claims, loss or damages
> of whatsoever nature, arising as a result of the
> reliance on such
> information by anyone.
>
> Whilst all reasonable steps are taken to ensure the
> accuracy and
> integrity of information transmitted electronically
> and to preserve the
> confidentiality thereof, Dimension Data accepts no
> liability or
> responsibility whatsoever if information or data is,
> for whatsoever
> reason, incorrect, corrupted or does not reach its
> intended destination.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: George Leonard (ZA)
> INET: George.Leonard_at_za.didata.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail :
http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 02 2002 - 11:13:26 CDT