Sample PLSQL program or anonymous block to send PDF document to a package for esign
Thursday, July 13, 2023 at 01:49pmHello, I want to send a pdf file using e-sign. I sent a file (by creating transaction) using sandbox account manually and I want to do the same via rest api. Could you please share the anonymous block or wrapper program to call send a pdf file to the existing package.
Reply to: Sample PLSQL program or anonymous block to send PDF document to a package for esign
Thursday, July 13, 2023 at 02:42pmHi 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
Reply to: Sample PLSQL program or anonymous block to send PDF document to a package for esign
Thursday, July 13, 2023 at 03:08pmI 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.
Reply to: Sample PLSQL program or anonymous block to send PDF document to a package for esign
Thursday, July 13, 2023 at 03:22pmHi 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