The stored procedure invocation only returns the last line of a .dat file
Summary
the stored procedure invocation only returns the last line of a .dat fileContent
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.
Tagged:
0