HINA SOFTWARES - NOW IN ABABIC  &  MALAY, MANDARINE LANGUAGES

Hina Softwares delivers accounts software, billing software, inventory software, medical software, ERP software, textiles software, school management software, college management software, hotel management software, hospital management software, MLM (netwoking) software, bulk SMS softwares, android application..

[Read More...]

Send Tamil SMS through  Oracle Forms6i - PL/SQL Procedure

sms 24.06.2016

Forms 6i Coding

 select pri , com into pri , com from sms_com where rownum =1;
 IF pri = 'ON' THEN
     declare
         p varchar2(100);
    n varchar2(100) := ' Dear.'||initcap(:tb_personal.name);
    r varchar2(20) := :tb_personal.regno;
    m varchar2(100);
    co varchar2(100) := com;
    msg varchar2(1000);
    msg1 varchar2(1000);
    sms varchar2(100) :=  '+91'||:tb_personal.mobile1;
    por varchar2(100) ;
    por1 varchar2(100);
    INST_NAME VARCHAR2(100) ;
 begin
     :system.message_level := '20';
    select sum(b.amount) into p from tb_personal a, tb_billing b
  where a.regno = b.regno and b.parity = :block3.date_3 ;
  select initcap(inst_name) into inst_name from encrypt where rownum = 1;

  msg :=inst_name||n||' RollNo. '||r||' Receipt No '||:block3.date_3||' Amount Rs.'||p|| ' has been paid in your Account Thank You!';
    msg1 := msg;
  por:= '/port:'||co||' /nologo /nosummary';
  por1 := por;
  host('d:\11i\sendsms\sendsms.exe '||por1||  ' " '||sms||' "  " '||msg1||' "',NO_SCREEN);

  IF NOT Form_Success THEN
     Message('Error -- '||SMS||' Message not sent.');
     MESSAGE ('CHECK YOUR COMMUNICATION PORT');
     insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Not Sent',SYSDATE);
  ELSE
     Message(SMS||' Message Sent.');
     insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Sent',SYSDATE);
  END IF;
     end;
     commit;


sms 24.06.2016

[Read More...]

QAMAR's BLOG: Send SMS from Oracle Forms through USB Connected GSM Devices

QAMAR's BLOG: Send SMS from Oracle Forms through USB Connected GSM Devices

The Polytechnic

Hi I am Senthilkumaran Oracle 10g OCP DBA from Tamilnadu,, India

Easy way to send sms through Oracle 10g Forms 6i Reports 6i

See my demo from 

https://youtu.be/gLskpQ3W1Hk 
https://youtu.be/oBP2Rul0ww4
smscaster + third party control usage (Airtel)

its free

thanks

[Read More...]

Hina Softwares

Hina Billing Software (Since 2005)

(Admission + Billing + Accounts + Auditing + Expenses + Balance Sheet + Ledger Balance + SMS + Group SMS + Barcode + NoDue + TC + CC + Bonafide + Declaration Forms + Nominal Role + Govt. Related Forms + More than 100 Reports )

Features:

·         Oracle based First Software in Tamil Language with SMS Support in LOW COST, No Hidden Charges.

·         Software Available in following Languages English, Tamil, Malayalam, Telugu, Hindi, Arabic and Malay.

·         Fully Password Protected Bills & Receipts,

·         Front End : Python, Rail, Oracle Forms & Reports, Back End : Oracle 10g/11i Express, OS : Windows XP

·         Also available in Polytechnic Exam, Assessment, Library Management, Retail POS, Medical POS

Thanks to Our New Clients – Year 2016

·         National Institute of Polytechnic, Jayankondam

·         National Arts & Science College, Jayankondam

·         Nelliandavar Institute of Technology, Pudupalayam,Ariyalur

·         Modern Polytechnic College, Mahimaipuram, Ariyalur

·         Modern Arts & Science College, Ariyalur

·         Modern Matric Hr.Sec.School, Jayankondam

·         Musiri Institute of Technology, Musiri

·         Musiri MIT Education College for Women, Musiri

·         Meenakshi Ramasamy Arts & Science College, Thathanur, Ariyalur

·         Meenakshi Ramasamy Polytechnic College, Thathanur, Ariyalur

·         Meenakshi Ramasamy Engineering College, Thathanur, Ariyalur

·         Meenakshi Ramasamy Catering College, Thathanur, Ariyalur,

·         Meenakshi Ramasamy Educational Institute, Thathanur, Ariyalur

·         Meenakshi Ramasamy CBSE Vidyalaya, Thathanur, Ariyalur

·         Meenakshi Ramasamy Matric Hr.Sec.School, Thathanur, Ariyalur

·         Merit Educational Institute, Ariyalur

·         Pari Vallal CBSE School, V.Kaikatti, Ariyalur

·         Modern Nursery & Primary School, Kattumananrkoil

·         Don Bosco Hr.Sec.School, Varadharajanpet

·         Rajiv Gandhi National Hr.Sec.School, Nattarmangalam,

·         Government Middle School, Nattarmangalam

·         Mother Gnanamma Arts & Science College, Varadharajanpet, Ariyalur. etc.,

Reasonable Prices:

Institutions	1 Server with Client	If you want Extra (Each) Client	AMC
Nursery & Primary Schools	10,000/-	1,000/-	2,000/-
Middle Schools, ITI	10,500/-	1,250/-	2,000/-
CBSE Schools	15,000/-	1,500/-	2,500/-
Higher Secondary Schools	15,000/-	1,500/-	2,500/-
B.Ed, Nursing Colleges	15,000/-	1,500/-	2,500/-
Polytechnic Colleges	20,000/-	2,000/-	2,500/-
Arts & Science Colleges	20,000/-	2,000/-	2,500/-
Engineering Colleges	30,000/-	3,000/-	3,500/-

Contact: (For Free Demo CD, Information)

Senthilkumaran R	9952784002
Oracle 10g OCP DBA	8012784989
HINA SOFTWARES	abisekblogger@gmail.com       WebSite :       http://goo.gl/2QRs2B

hina billing demo

https://youtu.be/gLskpQ3W1Hk

https://youtu.be/oBP2Rul0ww4

[Read More...]

Installing Oracle forms6i d2k

How To Install D2K(Developer Two Thousand) or Forms & Report In Your System

Requirement

OS window xp
(on 7 or 8 it will also install but some features not working properly so prefer xp or use vmware)


After download of developer 6i, Install developer 6i in your system
if you want to install it on Window7 or Window8 then change the compatibility mode to xp.
Developer 6i (download it from here: developer6i)
Oracle database(pre installed)

Installation Steps
Download the Developer 6i from above link and extract it. extracted size will be 614 or 621 MB.
Its very good choice if you install it in window xp or you can install it on 7 or 8 also but some features will not work properly in 7 or 8.

open the extracted folder developer 6i

[Read More...]