Java with Oracle Forms 10g- Sending SMS messages

14

Posted by Hafed | Posted in Forms, oracle | Posted on 11-01-2009

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:

Comments (14)

please upload its english version. that will be of great help to learn this interesting article.

Very Interesting and Knowledgeable Resource!!!
English version is needed.
Kindly post that also.

Very enthusiastic for the english version of this article!!

In the works, should be available very soon. I am working on finishing up the rich text editor for Forms. Bear with me …

I m still waiting for the English version of this article. If you have some spare time, please translate it.

Pls load simple version of this tuto
rial soon

where is english version of this documents pls?

Pls Send me the English version.

Hello,
Thanks for this article. Its indeed a great article for Forms Developers. I fully agree that Forms Developers do not know much about Java and if its powerful features can be used then it should be used.
Please send me the english version of this tutorial.

Thanks
fm

Please upload the English of this article. It is marvelous article.
this great article makes a path to access java beans in 10g form.
keep continue

Hi,

Could you please send me the English version of tutorial at my yahoo id tripakhil@yahoo.com.

Java with Oracle Forms 10g- Sending SMS messages

Thanks
AKhil

Still not English Ver.

Hi,

Could you please send me the English version of tutorial at my m_rashid_m@hotmail.com

Everyone i need sms sending loop form oracle 10g.
if anyone then send me email n_zorakzai@yahoo.com

Write a comment