Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Supporting multiple oracle versions in a trigger

Supporting multiple oracle versions in a trigger

From: Jack Addington <jaddington_at_shaw.ca>
Date: Wed, 19 Oct 2005 18:54:57 GMT
Message-ID: <5Ew5f.240781$tl2.182354@pd7tw3no> 





I have a storedproc that drops/creates tables using dynamic sql.  I also 
have clients in both 10g and 9i and for those in 10g I wanted to include the 
purge command as part of the drop as there is no need for these tables to 
clutter the recycle bin.



    
  
  1.   I'm assuming there is some sort of session variable that tells me the 
major server version?

  
  2.   Is this a bad approach?  It seems ok given its dynamic sql...






thx



Jack 
Received on Wed Oct 19 2005 - 13:54:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US