Tuesday, July 17, 2018

Convert Reports (11g) in different formats (HTML, RTF, XLS, PDF) / Download 11g reports in different formats

Hi guys, here I am again after a long time break :) 

So, now a days people are asking about development stuff more than administration, so I decided to continue my post again. 

Well above is the Form I created to email payslips to employees at the end of each month after payroll completed. In this both things covers , but this post I will be explaining for creating 11g reports in different formats like HTML, PDF, RTF, and EXCEL.

So as you knew that in 11g you need to first generate the report on application server, download it at client's PC and then you will able use that report.

Monday, July 25, 2011

Send SMS from Java through text/csv file

Hi Guys, 

Me again with a newer version of my existing JSmsGateway application with text file support :)

Now you can send messages from a simple text or csv file using your usb connected gsm mobile.

There are few new features included in this application with bugs fixed:

Monday, March 14, 2011

How to Replace Oracle Forms Runtime Files in Production Environments 'On The Fly'

This post describes how to replace forms runtime modules without bringing down the Forms Runtime Environment (OC4J_BI_Forms Instance in 9i/10g and Forms Server or jserv) in production systems.

Tuesday, February 15, 2011

How to Print Oracle Report To A Network Shared Printer

In this post I will demonstrate how to send Oracle Report print job direct to a network shared printer.(WINDOWS ONLY)

Assuming you are running your application on Oracle Application Server 10g.

Tuesday, October 26, 2010

Send SMS from Java. A Java Sms Gateway for Oracle & SQL Server

Hi folks :)
Me again with a great application.

Here it is a stand alone java application which supports Oracle/SQL Server database connectivity to fetch text messages and send it to desired number through your USB connected gsm devices.

Thursday, August 19, 2010

The procedure entry point _except_handler4_common could not be located in the dynamic link library msvcrt.dll

Hi guys, If you are facing this error continuously whenever you click any program or software such as: firefox, msnmessenger, or any other program, and you have done all your efforts to get rid of this error, just follow these 2 simple steps solution:

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.