Skip to Main Content
  • Questions

  • Displaying Digital Signature in report as well as in Form module PO

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Nagu.

Asked: June 09, 2009 - 4:13 am UTC

Last updated: October 07, 2015 - 8:26 am UTC

Version: 9.2.0.6.0

Viewed 1000+ times

You Asked

Hello,

I want to know to upload the Digital Signature in database.
After uploading digital signature I want to populate those signature in report as well as forms as per condition employee name.
we need this in PO module the client want that signature in PO report and PO form in action history.

Thanks
S Nagurao

and Tom said...

given you don't even say what your digital signature is - you sort of assume "digital signature - it is a datatype or something" - I don't see how anyone could help you.


If your digital signature is of the "standard form" - whereby you take

a) the document to be signed, the PO I suppose
b) the users private key (from their PKI certificate perhaps)

to generate a message hash - that later given that same document AND the users PUBLIC key - we can verify that the document was signed by the holder of that private key.....


Then your digital signature is simply a RAW binary field, you would use the RAW datatype (or a varchar2 datatype twice as long as the raw field would be - to store the signature in ascii HEX characters).


So, your digital signature would just be data, nothing special - it is data you generate, store and use.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Probably images

Kim Berg Hansen, June 11, 2009 - 5:11 am UTC

I think the digital signatures in question are image files - either scanned or written on PDA's like UPS - which he would like to display those imagefiles in his Purchase Order forms and reports. The question I think is really how to upload images and display them in forms and reports :-)

digital signature

Yogesh, October 07, 2015 - 7:12 am UTC

HI Is there is a way to attach .pfx file in rtf or pdf template ??
Connor McDonald
October 07, 2015 - 8:26 am UTC

Check out webutil

http://www.oracle.com/technetwork/developer-tools/forms/webutil-090641.html

for uploading files from Forms
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.