RE: After logon trigger

Create
it Once not every time some one Logs in...
<FONT face=Arial color=#0000ff

size=2> 
The
table is notsimilar to temporary tables in SQl... They are Different..

<FONT face=Arial color=#0000ff

size=2> 
The
Table is visible to all sessions if u say they are Global temporary Tables.
<FONT face=Arial color=#0000ff

size=2> 
Yes
Logon triggers Fire Every time the User logon... But the second time onwards u will get a Error... The Logon triggers dont fire for Users with the DBA Role Enabled.
<SPAN

class=299352707-12122001><FONT face=Arial color=#0000ff size=2> 
<FONT face=Arial color=#0000ff

size=2>HTH
 
Best Regards, <FONT face=Arial
size=2>Ganesh R Tel  : +971 (4) 
397 3337 Ext 420 Fax : +971 (4)  397
6262
HP  : +971 (50) 7456019

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Peter.McLarty_at_mincom.com   [mailto:Peter.McLarty_at_mincom.com]Sent: Wednesday, December 12, 2001   11:00 AMTo: Multiple recipients of list ORACLE-LSubject:   After logon trigger<FONT face=sans-serif   size=2>Hi I am trying to use an
  after logon trigger to create a session temp table rather that create it at   the time the procedure that uses it calls it. Two reasons for doing this is   for performance ? the other is so that I can reference it in a cursor.

1. Do logon triggers not work if I logon with toad or similar tools 2) If 1 is wrong why when I have the following trigger in the database cant I see the table or use it after logging on <FONT face=sans-serif size=2>TRIGGER create_temp_table AFTER LOGON ON DATABASE DECLARE v_CreateString VARCHAR2(100); BEGIN <FONT face=sans-serif size=2>v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_stddev ( v_part NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS'; <FONT face=sans-serif size=2>EXECUTE IMMEDIATE  v_CreateString; END; <FONT face=sans-serif size=2>TIAPeter McLarty                   E-mail: Peter.Mclarty_at_Mincom.comTechnical Consultant        WWW: http://www.Mincom.comAPAC Technical Services     Phone: +61 (0)7 3303 3461 Brisbane,  Australia                Mobile: +61 (0)402 094 238           ----------------------                    Facsimile: +61 (0)7 3303 3048-- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.