Password Generation
Introduction/ Issue: Write the issue that you face or the issue that you want to provide a solution through this blog. Password generation based on input parameters (number of digits,…
Read MoreTelephone Number Format
Introduction/ Issue: Write the issue that you face or the issue that you want to provide a solution through this blog. Mobile number should be digits Why we…
Read MoreDynamic Visual Attribute
1. Overview This blog explains about, How to Set Current Record Color -Multi Color. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS 3. Use Case Create a Simple Tabular Block Create Visual Attribute with color Gray -Name it as ODD Create Visual Attribute with color Blue -Name it as Event In When-New-Record-InstanceCreate a Procedure 4. Architecture Oracle FORMS FORM Builder 5. Examples Step 1: Create one procedure in forms. Code: PROCEDURE Visual_attribute_dis_alt_rec IS cur_itm VARCHAR2 (80); cur_block VARCHAR2 (80) := :SYSTEM.Cursor_Block; curr_record NUMBER; BEGIN cur_itm := GET_BLOCK_PROPERTY (cur_block, FIRST_ITEM); WHILE (cur_itm IS NOT NULL) LOOP cur_itm := cur_block || ‘.’ || cur_itm; Curr_record := :SYSTEM.Cursor_Record; IF MOD (curr_record, 2) = 1 THEN SET_ITEM_INSTANCE_PROPERTY (cur_itm,…
Read MoreEmail Checking Validation function
1. Overview This blog explains about, how we can Email validation using PLSQL function. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle PLSQL 3. Use Case To Create one function in database 18C 4. Architecture Oracle Database Using Database 18C ORALCE PL/SQL 5. Examples Step 1: Create one function in Database. Create one function in database. Code: CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2) RETURN BOOLEAN IS lv_n_check_len NUMBER; lv_b_check_in_at BOOLEAN; lv_b_check_in_dot BOOLEAN; lv_v_extn VARCHAR2 (10); BEGIN lv_n_check_len := LENGTH (pi_email_id); pi_email_id := LOWER (pi_email_id); SELECT REPLACE (pi_email_id, ‘ ‘, ”) INTO pi_email_id FROM DUAL; SELECT REPLACE (pi_email_id, ‘”‘, ”) INTO pi_email_id…
Read MoreConfigure formsweb.cfg to Run Oracle Forms Application
1. Overview This blog explains about, how we Configure formsweb.cfg to Run Oracle Forms Application. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle Configuration Files 3. Use Case To invoke an application in Oracle Forms using URL, you must configure it in formsweb.cfg file. Then you would be able to access it by providing config parameter is equal to your application name 4. Architecture Oracle FORMS Using FORMS BUILDER 5. Examples Step 1: To add the below code in formsweb.cfg file [yourappname] workingDirectory=c:\serverdir\ userid=yourid/psw@orcl form=mainform.fmx Save the changes in formsweb.cfg file and then access it as follows. Step 2: Run Oracle Forms Application by using the below URL http://localhost:8889/forms/frmservlet?config=yourappname 6. Conclusion You can see above the application URL using the config parameter with your application name [yourappname], you defined in formsweb.cfg file using square brackets [].
Read MoreHow to Hide Password in Oracle Forms
1. Overview This blog explains about, how we can hide Password in oracle FORMS. In Oracle Forms, if you are creating any custom login screen or giving any password security option, then there is a need to hide the password. This…
Read MorePANCARD Validation – PL/SQL Function
1. Overview When we give PANcard, We are returning PANcard is valid or not. 2. Technologies and Tools Used The following technology has been used to achieve the expected output.…
Read MoreDynamic List of values (LOV)
1.Overview LOVs can be displayed by end user request (when an LOV is available), Most of the user does not know the item have LOV option. For this we add…
Read MoreCreating Excel File in Oracle Forms
Below is the example to create an excel file in Oracle Forms. Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package. Sample…
Read MoreUsing Find_Alert and Show_Alert in Oracle Forms
Introduction Show_alert is used to display model window messages in Oracle Forms and Find_alert searches the list of valid alerts in Form Builder, when the given alert is located, the…
Read More