Hi
I am working on an integration IN IFS Cloud, where in PLSQL code I am getting the document from document management (as BLOB) and want to send it to Connect to be uploaded to ftp server using FTP_SENDER. I cannot find any method in PLSQLAP_SERVER_API that can handle BLOB message.
Any suggestions would be greatly appreciated.
Thanks
Best answer by SimonTestard
I couldn’t find a method to do this natively in Apps 10 (Didn’t look in Cloud), so I had to build my own.
Note that this particular method is specifically built around retrieving BLOB Data from a File in an Oracle Directory, but it would be completely trivial to modify it to retrieve BLOB Data from the Database instead.
Edit: The community forum does not apparently let me copy paste my code in directly so I’ll attach it instead
I couldn’t find a method to do this natively in Apps 10 (Didn’t look in Cloud), so I had to build my own.
Note that this particular method is specifically built around retrieving BLOB Data from a File in an Oracle Directory, but it would be completely trivial to modify it to retrieve BLOB Data from the Database instead.
Edit: The community forum does not apparently let me copy paste my code in directly so I’ll attach it instead
Hi Simon
Thanks for your response. You confirmed that we cannot send binary document in core PLSQLAP_SERVER_API methods.:)
BTW, I also implemented custom method to create application message similar to your method. My method actually does not use PLSQLAP_SERVER_API at all but, instead, creates the app message, message body and runtime routing directly (using code from Create_Application_Message___ in PLSQLAP_SERVER_API) . And so, I think your method is better. I will try to implement it for my requirements.
Thanks and Best Regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
