- We have a Ascii Text file (EDI File) delimited with ‘*” in a FTP server
- We have to read the contents of this file and assign the FILE content to a String variable (In BPEL Process) and call a DB Package which has a CLOB parameter and assign the String variable to the CLOB parameter
- Call the DB Package .
I put a FTP Adapter to read the file information with Opaque option and had a RECEIVE Activity and an Invoke activity.
The Problem I face that my textual data is converted into encoded data and I don't have a way to get my EDI Textual data into a variable in SOA.
Most critical need is to be able to get the EDI Ascii data in the file to a variable in BPEL process and use this variable to assign it to the CLOB parameter in the Package. Any pointers to achieve will be a really help. Running short of time to finish this requirement and any pointers are welcome.
Thanks
Nagaraj.s