Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to sign PDF automatically from USB Token with APEX

Soukaina IDRISSISep 13 2019 — edited Sep 13 2019

Hi Experts,
I have to realize an application, which allows to select a list of documents (being in a table of the database) using IG, and to click on the button BTN_SIGN, the latter will be able to load the files selected by the user, in the server and then to sign them automatically throught the parameters (public key, private key, signature, and certificate) found in a USB (Im using a GEMALTO USB Key SmartCard) plugged into the client's machine.

Thank you for your suggestions, or tracks allowing me to achieve this.

Comments

GasparYYC

Hi.

You have to investigate if there are command line options to sign the documents.. If there are, then you can build an application that can read/select  the documents and apply the command line options via call to (as an example) an Operating System script with the the appropriate arguments.

This is not an easy task given that the functionality you're mentioning has to invoke some sort of functionality outside of the database and ORDS. Of course you can build a service that listens for the right arguments and the service is the one that completes the request, a service of this kind is not in scope of Oracle APEX capabilities, it would need to be a Java, Shell, NodeJS kind of service...  again, not an easy or beginner kind of task.

Good luck,

1 person found this helpful
Fernando Lima

I'm agree with the above commentary.

I have seen that the best way is use "java" to create a sign routine, and call it using database.

However, remember that you have to store some sign files on the server, hence, this task is very difficult to use on the client side.

1 - 2

Post Details

Added on Sep 13 2019
#apex-discussions, #pdf
2 comments
789 views