Reason is very simple you are updating the fields in most probably post-query or other trigger. when any field changes, the changes ask to save it.
Solution is also very simple:
Use below line at the end of all post query triggers:
set_record_property(:system.
OR
Use: set_item_property(<block_
This section explains how to specify the default location and search paths for icons and images in Registry.dat.
Use Application Server Control to change, add, or delete parameters from Registry.dat.
To change a Registry.dat parameter value:
Select the Configuration page of Enterprise Manager.
From the View dropdown list, select Forms Font and Icon Mapping (Registry.dat).
Select a radio button next to a parameter and change the value(s) for it in the Value text field.
Click Apply.
Your changes are saved.
To add a Registry.dat parameter and its value:
Select the Configuration page of Enterprise Manager.
From the View dropdown list, select Forms Font and Icon Mapping (Registry.dat).
At the bottom of the Registry.dat page, enter a name for the parameter in the Name text field.
Enter a value for this new parameter in the Value text field.
Click Add New Parameter.
Your changes are saved.
To delete a Registry.dat parameter and its value:
Select the Configuration page of Enterprise Manager.
From the View dropdown list, select Forms Font and Icon Mapping (Registry.dat).
Select a radio button next to a parameter and click Delete.
The Confirmation page appears, click Yes.
The parameter is deleted and the Configuration page reappears.
When deploying an Oracle Forms application, the icon files used must be in a Web-enabled format, such as JPG or GIF (GIF is the default format).
By default, the icons are found relative to the DocumentBase directory. That is, DocumentBase looks for images in the directory relative to the base directory of the application start HTML file. As the start HTML file is dynamically rendered by the Forms Servlet, the forms directory becomes the document base.
For example, if an application defines the icon location for a button with myapp/<iconname>, then the icon is looked up in the directory forms/myapp.
To change the default location, set the imageBase parameter to codebase in the Forms Web Configuration page of Enterprise Manager Application Server Control Console. Alternatively, you can change the default.icons.iconpath value of the Registry.dat file in the forms/java/oracle/forms/registry directory.
Setting the imageBase parameter to codebase enables Oracle Forms to search the forms/java directory for the icon files. Use this setting if your images are stored in a Java archive file. Changing the image location in the Registry.dat configuration file is useful if you want to store images in a central location independent of any application and independent of the Oracle Forms installation.
If an application uses a lot of custom icon images, it is recommended you store icons in a Java archive file and set the imageBase value to codebase. The icon files can be zipped to a Java archive via the Jar command of any Java Software Development Kit (Java SDK).
For example, the command jar -cvf myico.jar *.gif packages all files with the extension .gif into an archive file with the name myico.jar.
In order for Oracle Forms to access the icon files stored in this archive, the archive needs to be stored into the forms/java directory. Also, the name of the archive file must be part of the archive tag used in the custom application section of the formsweb.cfg file (for example, archive_jini=frmall_jinit.jar, myico.jar). Now, when the initial application starts, the icon files are downloaded to and permanently stored on the client until the archive file is changed.
Note: You do not need to deploy Oracle Forms default icons (for example, icons present in the default smart icon bar), as they are part of thefrmall.jar file. |
If you want to add icon changes to the Registry.dat file used by your application, it is recommended that you make a copy of the existing Registry.dat file and edit the copied file.
To create a copy of the Registry.dat file:
Copy the Registry.dat text file found in the ORACLE_HOME/forms/java/oracle/forms/registry directory to another directory. This directory must be mapped to a virtual directory for your Web server (for example, /appfile).
Rename this new file (for example, myapp.dat).
Modify the iconpath parameter specifying your icon location:
default.icons.iconpath=/mydir or http://myhost.com/mydir
(for an absolute path)
or
default.icons.iconpath=mydir
(for a relative path, starting from the DocumentBase Directory)
Modify the iconextension parameter:
default.icons.iconextension=gif
or
default.icons.iconextension=jpg
To reference the application file:
In a specific named configuration section in the formsweb.cfg file, modify the value of the serverApp parameter and set the value to the location and name of your application file.
For example:
[my_app]ServerApp=/appfile/myapp
(for an absolute path)
or
[my_app]ServerApp=appfile/myapp
(for a relative path, relative to the CodeBase directory)
"Icon Location Guide" describes the correct locations where to place your application icons:
Icon Location Guide
| Icon Location | When | How |
|---|---|---|
DocumentBase | Default. Applications with few or no custom icons. | Store icons in forms directory or in a directory relative to forms. |
Java Archives | Applications that use many custom icons | Set |
Registry.dat | Applications with custom icons that are stored in a different location as the Oracle Forms install (can be another server). Useful if you need to make other changes to the Registry.dat file like font mapping. | Copy Registry.dat and change ServerApp parameter in formsweb.cfg. |
When you deploy your applications, you have the ability to specify a splash screen image (displayed during the connection) and a background image file.
Those images are defined in the HTML file or you can use the Forms Web Configuration page in Enterprise Manager:
<PARAM NAME="splashScreen" VALUE="splash.gif"><PARAM NAME="background" VALUE="back.gif">
The default location for the splash screen and background image files is in the DocumentBase directory containing the baseHTML file.
Each time you use an icon or an image (for a splash screen or background), an HTTP request is sent to the Web server. To reduce the HTTP round-trips between the client and the server, you have the ability to store your icons and images in a Java archive (Jar) file. Using this technique, only one HTTP round-trip is necessary to download the Jar file.
The Java SDK comes with an executable called jar. This utility enables you to store files inside a Java archive. For more information, see http://java.sun.com/.
For example:
jar -cvf myico.jar Splash.gif Back.gif icon1.gif
This command stores three files (Splash.gif, Back.gif, icon1.gif) in a single Jar file called myico.jar.
The default search path for the icons and images is relative to the DocumentBase. However, when you want to use a Jar file to store those files, the search path must be relative to the CodeBase directory, the directory which contains the Java applet.
If you want to use a Jar file to store icons and images, you must specify that the search path is relative to CodeBase using the imageBase parameter in the formsweb.cfg file or HTML file.
This parameter accepts two different values:
DocumentBase The search path is relative to the DocumentBase directory. It is the default behavior.
CodeBase The search path is relative to the CodeBase directory, which gives the ability to use Jar files.
In this example, we use a JAR file containing the icons and we specify that the search should be relative to CodeBase. If the parameter imageBase is not set, the search is relative to DocumentBase and the icons are not retrieved from the Jar file.
For example (formsweb.cfg):
archive=frmall.jar, icons.jarimageBase=codebase
The icons and images search path depends on:
What you specify in your custom application file (for the icons).
What you specified in the splashScreen and background parameters of your default Forms Web configuration or HTML file (for the images).
What you specify in the imageBase parameter in the Forms Web Configuration page of Application Server Control for the file or HTML file (for both icons and images).
Forms Services searches for the icons depending on what you specify. This example assumes:
host is the computer name.
DocumentBase is the URL pointing to the HTML file.
CodeBase is the URL pointing to the location of the starting class file (as specified in the formsweb.cfg file or HTML file).
mydir is the URL pointing to your icons or images directory.
The default search paths for icons and images are relative to the DocumentBase. In this case, you do not need to specify the imageBase parameter:
Search Paths for Icons
| Location Specified | Search path used by Forms Services |
|---|---|
default |
|
(specified in your application file) |
(relative path) |
(specified in your application file) |
(absolute path) |
Search Paths for Images
| Location Specified | Search path used by Forms Services |
|---|---|
file.gif (specified, for example, in formsweb.cfg as splashscreen=file.cfg) |
|
|
(relative path) |
|
(absolute path) |
Use the imageBase=CodeBase parameter to enable the search of the icons and images in a Jar file:
Icon Search Paths Used by Forms Services
| Location Specified | Search Path Used by Forms Services |
|---|---|
default |
|
(specified in your application file) |
(relative path) |
(specified in your application file) |
(absolute path) No Jar file is used |
Image Search Paths Used by Forms Services
| Location Specified | Search Path Used by Forms Services |
|---|---|
file.gif |
|
(specified in your HTML file) |
(relative path) |
(specified in your HTML file) |
(absolute path) No Jar file is used. |
Click to download this document.
Step1: Scroll Down the page
Step 2: Click on Administration
Step 3: login with admin user
Step 4: Click on Create Workspace
Step 5: Enter workspace name
Step 6: Select schema
Step 7: Enter Administrative username and password and also
email_id
Step 8: Click on create workspace
Step 9: Login to your workspace
Click to download this document.
Step 1: Download and extract the file apex_20.1_en to
apex_20.1
Step 2: Connect db as sysdba and execute command “@apexins.sql
sysaux sysaux temp /i/”
Step 3: Execute command “@apxchpwd.sql” after execution
press enter it will select admin username by default
Step 4 : now enter email id
Step 5: Enter your password according to policy
Step 6: Execute command “@apxldimg.sql C:\apex_20.1”
Step 7: Execute command @apex_rest_config.sql” and set
password same as before
Step 8: Execute command “@apex_epg_config.sql”
Step 9: Execute below commands
“EXEC DBMS_XDB.sethttpport(8080)”
“alter user ANONYMOUS account unlock”
“alter user XDB account unlock”
Step 10 : now open link on your browser “http://localhost:8080/apex”,
Thank you.
First of all I would like to thank my friend Mr. AhsanHussain for this wonderful document to help us understand the Oracle Database connection with PHP in an easy way.
