Hi Experts,
I facing issue in output spool file column names display.
Actually I SPOOL data to an output csv file and we are getting all column names and column data good as expected. But when i run the sql script through unix shell script only, first 9 columns are dumped to the output file. Important point is, all column values are displayed but only first 9 column names are in the file..Below is the output data.
TABLE_NAME | PRICE_VALUE | PRICE_TKT_PRICES | POST_PUR_COMM_RATE | PRICE_RATE | SH_POLICIES_RATE | TICKET_DELIVERY_RATE | SATISFACTION_RATE | LIKELIHOOD_PUR_ONLINE_RAT | | |
DW_BUYR_FACT | 2887631 | 2658080 | 31329496 | 27192668 | 27928269 | 33247628 | 30558043 | 30870542 | 27626706 | 30246062 |
As you can see from above sample that last two column names are not displayed but column values are displayed. This happens for all output. This issue is not coming when we run the sql scripts manually in toad window but when executed through shell script we face this issue.
I have set the property as SET LINESIZE 30000.So it should display all column names. But still i am facing the issue.
I know you will think this is not 100% oracle related but have some UNIX part. I understand that but i searched google and reached people but no solution.So i posted here so that i may get some help or direction from people.
So please help me with this issue. It will be a really a great help for me.
Thanks
Bhaskar.S