Monday, July 26, 2010

Calling Java from PL/SQL inside Oracle database

How to call java classes inside PL/SQL:

Senario: In this example I have implemented Digital Signature Verfication funtion inside PL/SQL using java classes.


Step 1: Create a java class in any text editor or IDE, i have created this class in NetBeans 6.

Friday, July 16, 2010

Send SMS from Oracle Forms through USB Connected GSM Devices

A Java Bean to load USB connected GSM Devices and Send unlimited bulk sms to any network.



Tuesday, March 16, 2010

How to run Oracle Forms on Sun JRE

Running Oracle Form Application on Sun JRE instead of Oracle Jinitiator

Configuring Sun JVM 1.6.0_18 to run Oracle Applications. (MicroSoft Windows)



Monday, March 15, 2010

Transaction Signing in Oracle Forms using Digital Certificates

I have implemented transaction signing in Oracle application using digital certificates. Created a java bean to access windows default keystore (SunMSCAPI) to get all certificates and populate them in oracle forms application, Signing oracle forms data of all columns and storing the signature with publickey in the database.