Sample PLSQL program or anonymous block to send PDF document to a package for esign

Hi Suresh,

Thanks for your post! 

I do have a blog series showcasing how to invoke APIs and create transactions from Oracle PL/SQL:

https://www.onespan.com/blog/onespan-sign-developer-integrate-oracle-plsql-part-1

https://www.onespan.com/blog/onespan-sign-developer-integrate-oracle-plsql-part-2

https://www.onespan.com/blog/onespan-sign-developer-integrate-oracle-plsql-part-3

https://www.onespan.com/blog/onespan-sign-developer-integrate-oracle-plsql-part-4

Kindly follow the blogs and let me know how it works for you.

Duo

I attached the anonymous api call which i use to call the send document api. its throwing me below error. Could you please help me out.

l_http_req_clob : 
--------------------------315851022762208958731210
Content-Disposition: form-data; name="file"; filename="Test_2.pdf"

Response> Status Code: 500
Response> Reason Phrase: Internal Server Error
Response> HTTP Version: HTTP/1.1
Response> Date: Thu, 13 Jul 2023 20:01:53 GMT
Response> X-Frame-Options: SAMEORIGIN
Response> Strict-Transport-Security: max-age=31536000
Response> X-Powered-By: Servlet/3.0
Response> Content-Type: application/octet-stream
Response> Content-Language: en-US
Response> Set-Cookie: NSC_uetjho-ucf_443=ffffffff3b4435dd45525d5f4f58455e445a4a4212d3;expires=Thu, 13-Jul-2023 20:03:53 GMT;path=/;secure;httponly
Response> P3P: CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
Response> Connection: close
Response> Transfer-Encoding: chunked
Response> Set-Cookie: NSC_Etjho_443=ffffffff3b4435db45525d5f4f58455e445a4a42378b;expires=Thu, 13-Jul-2023 20:03:53 GMT;path=/;secure;httponly
ORA-29266: end-of-body reached
ORA-29266: end-of-body reached
PL/SQL procedure successfully completed.

Hi Suresh,

I don't currently have Oracle database installed in my laptop, it could take some time to set up.

I noticed in your code, the API URL is "https://dxxxv/api/packages/" instead of "sandbox.esignlive.com", is it a reverse proxy set up internally? Are you able to directly connect to sandbox.esignlive.com to make sure the response coming from OSS server?

Without being able to execute your script, could you also give the example codes in blog1 and blog2 a quick attempt? You should be able to test connection with the code in blog1, and use the code in blog2 to invoke a POST multipart/form-data call.

Duo