Friday, December 22, 2017

Highway For Oracle Apex

Highway For Oracle Apex 


    In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

       May be you are anxious to try Oracle Apex by yourself. This article mainly presents to you a high way to Oracle Apex.
     It offers you a free Oracle Apex work space to try it yourself easily and  simply. 
       Let's follow the next steps below you will be able to feel and taste the beauty and capabilities of this wonderful technology.    


Task Definition:   


Create a new free Oracle Apex workspace. 
Hence, i will share all the difficulties i faced and discuss it with you.

Thursday, December 21, 2017

Oracle Forms 10G Installation For Oracle Designer


Oracle Forms 10G Installation
 On Windows 8.1 & Windows 10 64 bit



 In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


              Oracle  Developer Suite 10G still compete with Oracle Developer Suite 11g & 12c in regard to its convenient installation and common configuration. Although, Oracle no longer supports Oracle Developer Suite 10G but, it involves the latest Oracle Designer available for download at Oracle Official Site. 
     
       The significant installation problem is a compatibility problem. Oracle Developer 
Suite 10G is  no longer compatible with the new OS as Microsoft Windows 8.1 
 The need for Oracle Designer never stops and the client's old applications still running. These were two reasons to illegally create some work around.
  (May Allah Forgive Us ) to cope with the new Operating System.  

Task Definition:   

    Oracle Developer Suite 10G Installation for Oracle Designer. On Windows 8.1 64 bit


Oracle  Database Function
( Create & Call )


In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


      This is just an example of  Oracle Database Function to show you how can we create and call it as an individual database function not related to any PL/SQL package. Later on, In shaa Allah, we will declare and implement it with it's related database functions in a new package called a trans_pkg. 
Now, let's start the current task definition.


Task Definition:   

      1- Get the maximum quantity for each item stored in a specific  storage area.
     2- Update its maximum quantity in  the transaction table. 


Oracle PL/SQL Package

Oracle PL/SQL Package

      In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


      It's really a good practice to relay on PL/SQL Packages. Oracle bundle related PL/SQL programming resources into PL/SQL Packages.
It comprises  all the database triggers, procedures, functions and  etc.


PL/SQL Packages Advantage :

1.     Modularity:  One package  for a specific module or function.
2.      Security:      Granting privileges enhance security.
3.     Better Performance:  Loading multiple objects into the memory at once helps in reducing the traffic and increasing the performance.


 Task Definition:   

    Create PL/SQL Package  to group all related database  functions expected to return the name or the descriptions of all lookup tables created within  your application.


Wednesday, December 20, 2017

Oracle Flags Validation


In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

     Flags are useful in Oracle form validations. It's value can be stored into the database or it can be handled from form side. It can be represented in many different forms e.g. a checked box, a radio box or a static drop down list.


Task Definition:   


Validate a database  flag.


Oracle Report Layout
Confine Mode Vs. Flex Mode


In the name of Allah, Most Gracious, Most Merciful      
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

 This is a reminder upon request to Oracle developers concerning dealing with two main component modes of  Oracle Report  layout.

  •        Confine Mode.
  •        Flex Mode.

       These two modes  control  the management of  your report frames and fields. wizards can do the initial layout but wizards are always unsatisfied; you must modify the layout manually. Here comes the need to recognize the functionality of Confine and Flex modes to deal with them efficiently.


Tuesday, December 19, 2017

Start Learning &Tasting Oracle Apex

Start Learning & Tasting  
 Oracle Apex


In the name of Allah, Most Gracious, Most Merciful      
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

  • If you think its time to start a forward step into a promising career.
  •  If you think of upgrading your skills to learn a new web technology.
  •  If you think of the easiest way to develop fast attractive web application.

             Then, you should first pray to Allah "Estikharah" to guide you in shaa Allah
 to the best career path. Then, after praying, if your heart feels comfortable with choosing the web technology path  then i do re-command you to start learning the promising Oracle Apex technology


       In shaa Allah, the next following lines will define to you:


  • what is Oracle Apex?
  •  why do customers are increasingly looking for upgrading their old oracle forms applications?
  • How can you get a free on line access to Oracle Apex Work Space?
  • What are the basics skills you need to learn Oracle Apex?
  •  What is the starting point you are looking for to start learning Oracle Apex; this includes all the most simplest and reliable tutorials in both languages English and Arabic.
  • Where can you get the technical support?


        Well, Oracle apex is a 100% browser-based rapid application development (RAD) tool that helps you to create rich, interactive, Oracle-based web applications very quickly and with relatively little programming experience effort. 



Why Do Customers Choose Oracle APEX ?

·        Fully supported by Oracle.
·        No cost feature of the Oracle Database.
·        Low code means higher productivity with less experience & effort.
·        Interactive Web based & Mobile Technology.
·        Ultimate  Security since APEX is an Oracle database feature.
·        Familiar to developers using SQL and PL/SQL.
·        Distinctive Interactive Reports & charts for your application & more.
    

Do you like Oracle Apex benefits? 

If the answer is yesss then try it yourself with no need for an installation. 
Oh yes it's really true, the following are three steps that can helps you just keep on reading ...

.

Saturday, December 2, 2017

Handling Oracle Forms Sequence


In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


     You can smartly handle the Oracle forms sequence for your application with No Gaps as follow:


Task Definition:   


Increment a data block serial no by 1.



Sunday, November 12, 2017

Configure Forms 10g On Oracle 11g


Configure Forms 10g On Oracle 11g


In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


     Despite the new Oracle technologies, i noticed that Oracle  forms 10G still the favorite version  for a large sector of companies around the Arabic and far east World. Besides the CS students are still looking forward to install and  learn as a training.


Oracle  forms 10G is NOT compatible with Microsoft Windows 8.1 Operating System.   So we had made some workarounds. Once it is successfully installed then, it is time to configure. The next step you should look forward is configuring Oracle Forms…

Why do we need to configure Oracle Forms 10G ?

 The answer is simple; we configure it to run it successfully on the browser.

Task Definition:   

Configure Oracle forms 10G 

 The significant importance of configuring Oracle Forms guarantees a successful running on browser. 
Let's try to run Oracle forms without configuration you will face the following forms errors…

Open Oracle form builder and press run button

Oracle Forms asks you the following question



Press yes and input your connection strings
You will step into a sequenced error messages you have to solve as follow: 


Thursday, June 8, 2017

Data Validation


In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


        A reliable application, relies on data validation methodology. It involves     
  recognizing the business rules and applying the five  types of data validations. 

 Data Validation Types:

1.     Code validation 
2.      Data type validation 
3.      Data range validation
4.     Constraint validation
5.      Structured validation

Task Definition:   

    Today's task is to use data validation in a specific formula. This requires you to check out the input of the left hand side must logically equal the right hand side of the mathematical equation.
   
     Let's assume that we have an estimated plan for issuing the total annual quantities of the raw material for production in a factory. Then, the system should check for accurate user input before saving; the estimated total quantity must equal all raw material quantities entered by the user. 

e.g.   Total =  item1 +  item2 +  item3 

 If the logical equation violated, then you must prevent the user from saving the data into the database.


Task Solution:

 There are two ways to apply a solution for this task:


1- Create WHEN-VALIDATE-RECORD Trigger (block level)


DECLARE

    v_total   NUMBER  :=0 ;

BEGIN
     
     v_total  := NVL(:item1,0) + NVL(:item2,0) + NVL(:item3,0) ; 

IF tot  <> :total THEN

     -- Create a message or Alert here 

MESSAGE('Quantities Don't Match');

PAUSE;

 RAISE FORM_TRIGGER_FAILURE;

END IF;

END;




If  the data validation is accurate, it works fine. Otherwise the data condition will be violated and the trigger will fire to Prevent inaccurate data from saving the form.


2- Create PRE-INSERT or PRE-COMMIT Trigger ( form level)


DECLARE

     v_total  NUMBER  :=0 ;

BEGIN

    v_total  := NVL(:item1,0) + NVL(:item2,0) + NVL(:item3,0) ;

IF v_total  <> :total THEN

     -- Create a message or an alert here 

MESSAGE('Please Check Related Quantities to FormItem1');
PAUSE;

-- To prevent a user fro saving the violated condition use...

     RAISE FORM_TRIGGER_FAILURE;

END IF;

END;




Learn more about:

           Oracle Report With No Data
·          Oracle Forms Data Exchange
·           


Hope this helps...

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.





Sunday, January 15, 2017

A Report With No Data

  A Report With No Data

  

       In the name of Allah, Most Gracious, Most Merciful 
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

        The Oracle Report is a visual representation of the company data stored in one or more database tables or views. If your report is running correctly, this means, your code behinds calling this report works just fine. In fact, It is just all about the 
execution of a code to achieve the report mechanism of calling it.

        On the other hand, a report running with no data does not mean your report is at the save mode. It's only a warning message that denotes one or more ambitious problems is waiting for you. Even though it is only one problem, but it.causes it has so many reasons 

    Today's task in shaa Allah, I will list the reasons for displaying a report with  no  data even though there is a data stored in the database.


Problem Definition:   

      A report with no data.


Problem Reasons:

 7 Reasons Leads To A Report With No Data:

          1.        No data stored into the database.
         2.        Invalid report query conditions.
         3.        Incompatible parameter name.
         4.        Incompatible parameter types.
         5.        The parameter numbers are not equal.
         6.        Invalid data input.
         7.        Invalid report name.


Problem Task Solution:

7 probabilities for a solution to a report with no data:

  •    Execute the report query into SQLPLUS or Toad to check for data. If it displays data then the problem exists either in the report or the parameter form.

  •     Comment each suspected condition at the where clause query line by line.Then, re-execute the query. Repeat these steps until you get the data displayed.
                
      Start inspection through checking up these questions with answers:

                         i.   Are the database tables' constraints and relationships correct?
                       ii.   Is there any incorrect data inputs by the user himself?  
               iii.    Is  the query parameters are logically correct?
               iv.     Is the  query parameters format mask matches?  
                  v.    Is the specified value for the parameter date has data?
              vi.   Is there any irrelevant conditions in the where clause of the report's query.

3.        Mismatch Parameters' Names 

      This means the report parameter name itself is not the same one as on the parameter form or page. You may have:

           ·        A spelling mistake; So you have to make sure that both names are the same. You may use, copy & pate just to assure equality on both sides.
          ·       One single extra space; using copy and paste may lead to one or more extra character space.
         ·  A colon character, You may copy the parameter preceding colon ':'  in the report query as follow:


 SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER, 'paramform=no'
                                      ||' :P_DEPT_ID='|| TO_CHAR(:DEPTS.DEPT_ID));

 Note:  The report will also display with no data just in case the report parameter has no initial value. Otherwise, it will display data upon the initial value.


4.        Incompatible Parameter Types

        The report parameters' types MUST BE compatible with the parameter form's parameters according to Oracle Explicit & Implicit Data Type Conversion rules, e.g. Oracle treats 1500 the same as '1500'. But using TO_NUMBER  function in a  string contains non-numeric characters, the function returns an error. 


 SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER, 'paramform=no'
                                               ||' :P_DATES='|| TO_CHAR(:EMP.HIRE_DATE, 'DD-MM-RRRR'));


Note:  All parameters in the parameter form called especially date & number parameter data type MUST BE in character data type. Otherwise, no data will be displayed. If  NOT the form item datatype is not defined as the character data type you MUST convert it using TO_CHAR()  as giving in the example.


5.        Unequal parameters' numbers: 

      The number of a report parameters referenced in the report query  MUST BE equal to the parameters' form numbers referenced in the parameter form's code. This involves one or more  extra parameter report not includes in the parameter  form or the vice versa .You have to count them and remove any redundant or extra parameters.


6.        Invalid Data Input:

       This may occur from the application user or the oracle developer or the application testers; they may input incorrect data when calling a report from the parameter form, a developer, e.g. may write the report query contains a range of  date  parameters as the following:
  

WHERE INVOICE_DATE BETWEEN :P_START_DATE AND :P_END_DATE

  
The wrong date input:
From: 15-01-2017   To: 01-01-2017   
  
The correct date input:
From:   01-01-2017    To: 15-01-2017

Note
         The date range is reversed, so you can solve this problem if you correctly reverse the wrong date range to the correct one. A good developer can expect this problem and handle it through writing a date range validation on each item on the parameter form to enforce the user to input the correct logical date range and etc.


7.        Invalid Report Copy:

         This case rarely happens, a developer may mistakenly replace an old report copy of the new one. So you have to pay more attention to this mistake. So you have to test and review all report copy from the correct working folder and the valid path. Making sure you have the correct generated run time copy of both the page or form and the report. 


Learn more about:

·        Calling Oracle Report 10G
·        Oracle Arabic Report 10G




Hope this helps...

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.