Hi, Use dynamic SQL (execute imediate).
Also, consider placing your code into a stored proc called by the trigger. --- "George Leonard (ZA)" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] ___________________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
