tag:blogger.com,1999:blog-5741898240771673922026-08-25T03:41:01.171+05:00QAMAR's BLOGSolutions for Oracle Applications/DatabasesQamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-574189824077167392.post-46025607950333609092018-07-17T00:41:00.002+05:002020-08-15T21:13:05.092+05:00Convert 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 Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com0tag:blogger.com,1999:blog-574189824077167392.post-17289217541307924552011-07-25T14:28:00.007+05:002011-07-25T15:57:39.909+05:00Send 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:
Auto Loads PDU/Text mode support for any mobile phone.
Simple text or csv file to load text messages Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com8tag:blogger.com,1999:blog-574189824077167392.post-83048100739544037442011-03-14T12:59:00.003+05:002011-03-14T13:02:22.124+05:00How 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.
On Unix, when you replace the runtime files in the OS level, then the sessions that are already using these modules will be disconnected with the following error message :
FRM-92101: There was a failure Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com0tag:blogger.com,1999:blog-574189824077167392.post-62882348237721919122011-02-15T12:29:00.011+05:002011-02-21T12:09:05.040+05:00How to Print Oracle Report To A Network Shared PrinterIn 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.
WHEN-BUTTON-PRESSED
DECLARE
pl_id ParamList;
lv_repid REPORT_OBJECT;
lv_report VARCHAR2(100);
BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com9tag:blogger.com,1999:blog-574189824077167392.post-31238547550404421302010-10-26T12:50:00.014+05:002010-10-26T20:36:27.614+05:00Send SMS from Java. A Java Sms Gateway for Oracle & SQL ServerHi 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.
FEATURES:
Auto loads all USB connected mobile phones in java application
Supported Mobiles : Nokia, Sony Ericson, Samsung, Motorola and LG
Connects Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com11Saddar Town, Karachi, Pakistan24.850755294270581 67.01344728469848624.850451294270581 67.012991284698487 24.851059294270581 67.013903284698486tag:blogger.com,1999:blog-574189824077167392.post-43081073200788186162010-08-19T13:27:00.004+05:002010-08-19T20:30:36.364+05:00The procedure entry point _except_handler4_common could not be located in the dynamic link library msvcrt.dllHi 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:
1. Browse to C:\Windows\System32 folder and file this file dwmapi.dll
2. Rename this file from dwmapi.dll to dwmapi.dll_old
Now you can Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com23tag:blogger.com,1999:blog-574189824077167392.post-32227772971385443862010-07-26T19:58:00.019+05:002010-07-27T11:30:53.162+05:00Calling Java from PL/SQL inside Oracle databaseHow 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.
// OracleVerifySignature.java
import java.security.KeyFactory;import java.security.spec.X509EncodedKeySpec;import java.math.BigInteger;import Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com2tag:blogger.com,1999:blog-574189824077167392.post-89641563884652928982010-07-16T11:01:00.009+05:002010-07-23T14:47:35.324+05:00Send SMS from Oracle Forms through USB Connected GSM DevicesA Java Bean to load USB connected GSM Devices and Send unlimited bulk sms to any network.
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-17604825-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com21tag:blogger.com,1999:blog-574189824077167392.post-22380485709309336682010-03-16T17:42:00.014+05:002018-07-14T00:28:45.059+05:00How to run Oracle Forms on Sun JRERunning Oracle Form Application on Sun JRE instead of Oracle Jinitiator
Configuring Sun JVM 1.6.0_18 to run Oracle Applications. (MicroSoft Windows)
Download Sun latest JRE version from : Sun Website
(In this configuration i am using JRE 1.6.0_18 and forms webutility already configured)
Install JRE by double clicking and follow the steps.
Configure your formsweb.cfg file Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com1tag:blogger.com,1999:blog-574189824077167392.post-32207240843956979102010-03-15T13:19:00.005+05:002010-03-18T10:28:39.075+05:00Transaction Signing in Oracle Forms using Digital CertificatesI 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.
Verification of tempered data through stored signature with Qamar Abbashttp://www.blogger.com/profile/11368943534560307656noreply@blogger.com14