Java with Oracle Forms 10g- Sending SMS messages
One of the ways to extend Oracle Forms 9i-10g is with the use of JAVA. However, a number of Forms developers can’t seem to come to terms with JAVA and are unaware of the possibilities they have with the combination Oracle Forms-JAVA.
I recently was about to give a presentation on JAVA for PL/SQL developers (similar to the one by Peter Koletzki), Anatomy of a PJC/Javabeans and JAVA in the Oracle Forms architecture. I thought then about putting together a tutorial so that someone familiar with Oracle Forms can rapidly grasp the basics of using Forms with JAVA.
Here is an example that shows how to send SMS messages through a Forms module. This follows the tutorial on OTN (http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html).
My objective here is to go over the OTN tutorial and show exactly why we are using one approach, namely using JAVA on the application server side, instead of the client side or the DB side.
I have to add that I ran into configuration issues that dealt mostly with classpath problems. In order to use the external SMS web services, there are a number of JDeveloper classes that need to be in the classpath when making calls through the Forms module. I show that in the tutorial.
Another approach, based on a stored PL/SQL procedure, was also used to demonstrate that we can also send SMS messages quite simply without any JAVA. However, the goal of this tutorial is to show how to put in place the bridge that allows a Forms module (PL/SQL wrapping) to use the functionnalities provided by JAVA classes on an application server.
The tutorial is in french and the english version will follow very soon.
Download tutorial envoi_sms_oracle_forms_10g
Similar Posts:
- Garnering interest for Oracle Developer day in Montreal, Canada
- JDeveloper 11g TP3
- Week2 – Migrating a mission-critical Oracle Forms 6 application
- Oracle Apex (HTMLDB) 2.2
- A migration dashboard with Forms JavaBeans
Make A Comment: ( 7 so far )
7 Responses to “Java with Oracle Forms 10g- Sending SMS messages”
Bilal
January 13th, 2009
Very Interesting and Knowledgeable Resource!!!
English version is needed.
Kindly post that also.
Bilal
January 19th, 2009
Very enthusiastic for the english version of this article!!
Bilal
January 22nd, 2009
In the works, should be available very soon. I am working on finishing up the rich text editor for Forms. Bear with me …
Hafed
January 22nd, 2009
I m still waiting for the English version of this article. If you have some spare time, please translate it.
Bilal
August 4th, 2009
Pls load simple version of this tuto
rial soon
sameer
October 9th, 2009
where is english version of this documents pls?
sameer
November 2nd, 2009
please upload its english version. that will be of great help to learn this interesting article.