Functions encrypt decrypt and checksum oracle

Tuesday, May 30th, 2017 (0 Comment)

In this article, we will have function create xml file with our key and we have to checksum oracle for this xml file.

At first, we need to research some functions as encrypt and deEncrypt in oracle.

1) Encrypt and DeEncrypt function in oracle

f_Encrypt

f_DeEncrypt

Run to testing

Output

2) Create xml file and checksum oracle

f_xml_template Function random generate xml file

f_GetTagValu function to get value of tag in xml file

f_SetTagValu function to set value of tag in xml file

Run to testing checksum oracle

  • Line 26: if we remove rem this line to set new time for CreateDate tag then checksum oracle is VerifyXml: File invalid

Output

 

Tags: , , ,

Related Posts

database
How to create function return table or cursor in oracle
database
Create group user class by using object oriented plsql
database
Create stored procedure pl/sql in oracle
database
Check tablespace usage percent in oracle

Related Posts

database
How to create function return table or cursor in oracle
database
Create group user class by using object oriented plsql
database
Create stored procedure pl/sql in oracle
database
Check tablespace usage percent in oracle

Leave a Reply

Your email address will not be published. Required fields are marked *