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 -> How do you run a query through DBMS_SQL that is longer than 2000 chars

How do you run a query through DBMS_SQL that is longer than 2000 chars

From: Matt Larson <matt_larson_at_jdedwards.com>
Date: 1998/01/30
Message-ID: <6atc4n$kgl$1@server1.incc.net>#1/1 







I have a procedure that creates triggers on my tables.  The create trigger
statement is often greater than 2000 characters long.  I have been using
DBMS_SQL to create the trigger automatically, but it limits the character
string which contains the query to only 2000 characters.  Any suggestions or
ideas?



Please email answers to matt_larson_at_jdedwards.com



Thanks in advance,


Matt
Received on Fri Jan 30 1998 - 00:00:00 CST












Original text of this message













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