Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
The stored procedure invocation only returns the last line of a .dat file — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

The stored procedure invocation only returns the last line of a .dat file

Received Response
15
Views
1
Comments
edited Feb 14, 2019 3:44PM in Integration 1 comment

Summary

the stored procedure invocation only returns the last line of a .dat file

Content

Hello everybody,

I am working on an integration which must obtain a .dat file from an EBS ftp server. The problem is that due to security I can not access ftp directly from OIC.

Then I am using an alternative through a query to the database I read the file that is in ftp when I show the output in console it is possible to see all the contents of the file but the problem starts when I invoke the stored procedure in OIC once I make the configuration so that I write the result in a file in another FTP only prints the last line of the read file.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!