Hi All,
I am facing some issue on csv file.
When I am developing the outbound interface, employee name (full name) is split into 2 columns.
code :
| V_Wstring := i.PO_Number | ||'|'|| i.line_num | ||'|'|| i.po_line_id | ||'|'|| |
| | i.VENDOR_PRODUCT_NUM | ||'|'|| i.item_description ||'|'|| i.quantity | ||'|'|| |
| | i.UNIT_MEAS_LOOKUP_CODE | ||'|'|| i.UNIT_PRICE | ||'|'|| i.VENDOR_ID | ||'|'|| |
| | i.Contract_Number | ||'|'|| i.VENDOR_NAME | ||'|'|| i.LOCATION_CODE ||'|'|| |
| | i.CREATION_DATE | ||'|'|| i.Promised_Date | ||'|'|| i.CANCEL_FLAG | ||'|'|| |
| | i.Source_Code | ||'|'|| i.employe_name | ||'|'|| i.Requisition_Number ; |
| UTL_FILE.Put_Line (V_File_Handle, V_Wstring); |
I need help with this same.
It will be great if some one could post such a working Pl/SQL code.
Thanks for your efforts.