Quote Originally Posted by chrisrlong
Okay, first of all, what clueless wonder decided the proper way to return data was to concat it all into a single string?



And you're going to need to provide a few more details if you want an answer. Like, what does the table look like and what does the calling code look like.

And more likely than not, the issue will have something to do with the length of the string you are building, and not how many columns went into it.

Oh, and what are the 12-byte values that are being returned?
Hi Chrisrlong

Thanks for your response.

The purpose of this query is to create a data file with '~' as the field delimiter and the it will be a variable record length. To achieve this we are concatenating the required columns with delimiter ~.

We suppose to get the result set of all the field values concatenated with delimiter but we are getting only first 32 characters of result.

The table is having a mix of VARCHAR2, NUMBER, and DATE data type columns (130 columns). During concatenation proper data type conversion is also taken care .

You may be correct it is some this to do with [I] and not the number of columns. Actually it was desinged for Pro*C and we have enough length declared. Unfortunately the same select statement is not working in SQL*Plus also.

Is it something to do with Parameters setting at Oracle level or Memeory constraint at OS level. For you information we are using AIX server and Oracle 9i database.

Regards
Muthiah