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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Procedure Versioning

Re: Oracle Procedure Versioning

From: Noodles <noodles_at_aol.com>
Date: 2000/07/16
Message-ID: <20000716081636.09791.00000111@ng-ff1.aol.com>#1/1 






If you look in user_source, you'll see that the text column ( long datatype)
stores the Procedure source code.   In the past, I've created a table with  PK,
version_id and procedure_text columns and just moved versions into that table
with simple SQL.  



It's not very elegant but it'll give you a history of the procedure source.



Cliff
Received on Sun Jul 16 2000 - 00:00:00 CDT












Original text of this message













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