Re:DBMS_SQL -- help needed

From: Vinay Joshi <vjoshi_at_pinnacle.co.uk>
Date: 1998/01/22
Message-ID: <717BDE76D864D011870F00A0C9283F1E104A27@exchange.pinnacle.co.uk>#1/1

Perhaps I misunderstood you, but I thought the limit was 2000 chars for a varchar2 datatype.
Oracle DBA/Support
Vinay Joshi
Pinnacle Insurance Plc

> -----Original Message-----
> From: Michael Will de Laforcade [SMTP:mwill_at_dris.com]
> Posted At: 21 January 1998 23:42
> Posted To: server
> Conversation: DBMS_SQL -- help needed
> Subject: DBMS_SQL -- help needed
>
> 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 Thu Jan 22 1998 - 00:00:00 CST