Noor Bappy - Oracle Specialist | Apex Expert

HOW TO CONNECT ORACLE 6i FORMS TO ORACLE 12c / 19c Pre-requisites Disable Case-Sensitive Passwords Developer 6i cannot handle case-sensitive logins introduced in 11g+. ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; (Now passwords are treated as u…

In Oracle Developer Forms 6i, We can easily browse and save Images in the database. Step 1: At first create a table with the following script: CREATE TABLE IMAGE ( ID                 NUMBER(10), IMAGE          LONG RAW ); Step 2 : Now create a form u…

We might want to click and  1 - Start Weblogic Admin Server 2 - Start Weblogic Server - WLS_FORMS 3 - Start Weblogic Server - WLS_REPORTS without giving any password create a file named boot.properties and add the following line: password=weblogic us…

How to Run Oracle 11g Report from Oracle Apex : Dynamic Action Javascript : var r_ip     = "DESKTOP-B2K7G7D"; var r_port   = "9002"; var r_url    = "/reports/rwservlet"; var r_dept_id = $v("P2_DEPT"); var r_link…

To manage Stock in the POS System, We can build a View with the following Tables : Products Purchase Details Sell Details Purchase Return Details Sell Return Details Damage View : CREATE OR REPLACE VIEW V_STOCK AS SELECT A.PRODUCT_ID,  NVL(A.STOCK,0) …

In order to run Report from Forms: You may want to call report from forms with or without parameter. You must call the following script from Forms: Without Parameter: DECLARE          rep_url varchar2(2000);          vDB     varchar2(10); BEGIN   :GLO…

Download Link :  https://drive.google.com/drive/folders/1sUqz5WIOnQzHtvjTeF_2h1ExX0x6dudV?usp=sharing 1-Purpose :   When you want to load images from the client machine to the database, you would like to choose the right image file with a preview of e…

Software Download Link :  https://drive.google.com/drive/folders/1IHAW3dl0pr86QOm5ZM7Nl2u-K-d8yLjx?usp=sharing Install-Oracle-Forms-Installations: Step 1: Go to : E:\app\Administrator\product\12.2.0\dbhome_1\network\admin\sqlnet.ora Add the followin…

Download Link : 1 - OPEN CALENDER.PLL AND stndrd20.olb 2 - GO TO : Object Libraries > COMPONENTS and click COMPONENTS. Another window appears. 3 - Drag and Drop the COMPONENTS to object navigator. 4 - Now Drag and drop :     PL/SQL Libraries > …

If you do not want to show the user name and password in the report url calling from oracle forms. You must create a CMDkey : C:\DevSuiteHome_1\reports\conf\rwservlet.properties change the following parameters to YES: SERVER_IN_PROCESS=YES RELOAD_KEYM…

PROCEDURE collapse_tree IS vnode ftree.node; vhtree ITEM; vstate varchar2(30); BEGIN -- Search the tree identifiant -- vhtree := Find_Item('MENU.TREE4'); -- Search the root -- vnode := Ftree.Find_Tree_Node(vhtree, ''); -- C…

--OPEN_form('C:\menutest\ONE.FMX',NO_hide,DO_replace,query_only,share_library_data); --call_form('C:\menutest\ONE.FMX',hide,do_replace,no_query_only,no_share_library_data); OPEN_form('C:\menutest\ONE.FMX',NO_hide,do_replace,NO…

Create CMDKey: Step -1: go to : C:\DevSuiteHome_1\reports\conf\rwservlet.properties change : SERVER_IN_PROCESS=YES RELOAD_KEYMAP=YES Step -2: Go to : C:\DevSuiteHome_1\reports\conf\cgicmd.dat Add this line at the bottom: lierp: Userid=U00001/U@RPRT%* …

When you install Oracle Developer Suite 10g Release 2 on windows 7 and try to open any form within the builder, you may face the following issues.. Oracle Forms Designer Has stopped Working Windows can check online for a solution to the problem. ---…

Some times   Oracle 10g Report Builder   stay minimized in  window 7. The main cause of this is: We close the Oracle Report Builder at minimized state. And afterwards, when we want to open Oracle Reports Builder, It opens in minimized and maximize opt…

How to install Oracle 11g Fusion Middleware in Oracle Enterprise Linux: User is : root When installation create partition named /data copy the Server folder from media to /data/Server copy the below files to /data   jdk-6u45-linux-x64.bin jre-6u45…

Required Software for Installing Oracle Developer Suite 10g: (Click and Download) Create shortcut in the batch file : "C:\Program Files (x86)\Safari\safari.exe" http://103.83.182.69:8889/forms/frmservlet?config=erp

Steps to complete Oracle 10g Developer Suite in Windows 7 : For Forms : 1. Increase Virtual Memory as recommended by the OS.    a. Go to systems @ control Pannel    b. Go to Advanced System Settings.    c. Click Settings at Performance Tab.    d. Cli…