Home » Developer & Programmer » Precompilers, OCI & OCCI » Want to Create Text File in Pro*C having data stored in oracle Table
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.
Previous Topic: Need help in making a Message Queueing program
Next Topic: Starter:To add sql commands in ProC.
Goto Forum:
  


Current Time: Thu Mar 28 10:44:30 CDT 2024