Unable to Read Shared Repository Document Attachment Contents as BLOB Values

Hi Nipun,

You need to explain in more detail what you are trying to do and what you have tried. It's not clear.

Thanks!

Hi @sajithmendis ,

Could you please explain the issue in more detail?

Thanks & Best Regards,

Nipun

@Mathias Dahl  - The customer upgraded from APP8 to APP10.  They use MWO.  Here is their initial issue from case G2317758:

 “Our database process that gathers and sends work task information as a JSON document to IndySoft (the external system now used by our Field Service technicians) is unable to read the contents of files from any Document Repository that is not located on the database server.

While we have set up a new repository that is located on the database server, there are many existing document attachments from before our IFS10 upgrade that need to be sent with task information, but are saved in a repository on a different machine. All attempts to get the document contents to add to the outgoing JSON have failed or have required manual preparation that we cannot ask our office personnel to perform before running the procedure.”

In addition, they say:

“Attempt to run the following sql in the Production database, which attempts to read file contents from one of the shared repositories:

select mac_work_order_api.loadBlobFromFile2('MWO_DOC-1001083-1-A1-1.PDF','MAC_HIST_WO_DIR') from dual

If successful, the select will return a single BLOB value representing the Base64 encoding of the PDF file. As of now, that select will return error ORA-22288.  Unless we follow the process detailed in the workaround section for a given document from one of the external shared repositories, the file will not be read by the DBMS_LOB functions in our process.”