| Want to Create Text File in Pro*C having data stored in oracle Table [message #94174] |
Thu, 15 April 2004 01:48 |
Lalit
Messages: 7
Registered: February 2002
|
Junior Member |
|
|
I want to create Text File in Pro*C having date stored in Oracle Table.
The Table Name & Structure will be dynamic in the sense the Table Name & Structure info will be stored in a Metadata table.
The record length may go upto 20,000 chars. The result File must have records stored in Fixed length format.
MetadataTable
--------------
Tab_Name Field_Name Field_Length
====================================
Dynamic Table Col1 4000
Dynamic Table Col2 4000
DynamicTable
--------------
Field1 Datatype
====================
Col1 VARCHAR(4000)
Col2 VARCHAR(4000)
I tried opening a Dynamic Cursor & putting the complete record in a Variable so that I can use that Variable to write into the file. But when I try concatenating fields having with 4000 chars oracle generates error:
ORA-01489: result of string concatenation is too long
Kindly suggest me any solutions.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
