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 -> DBMS_SQL -- help needed

DBMS_SQL -- help needed

From: Michael Will de Laforcade <mwill_at_dris.com>
Date: 1998/01/21
Message-ID: <6a6141$35g$1@client3.news.psi.net>#1/1

I have a situation where I need to dynamically create tables with 800 + columns from within PL/Sql.

I am running into the varchar2 limit of 400 chars max.

I tried submitting the create statement in chunks via multiple calls to dbms_sql.parse, but get errors.

Is there a way to get this to work??

Thanks in advance for all suggestions.

                    Michael..
Received on Wed Jan 21 1998 - 00:00:00 CST

Original text of this message

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