Oracle Application Development: 10gR2

Showing posts with label 10gR2. Show all posts

Sunday, August 23, 2020

REP-1060: Reports Builder database tables have not been installed.

Greetings from Hamid Blog

Issue on: Oracle Forms 10g, 6i

After opening the report builder, when you try to open an existing reports, you will get bellow error message.

REP-1060: Report Builder database tables have not been installed.
ORA-00942: table or view does not exist.
Report Builder tables may not be installed in the database.

cause: Database access is chosen in Reports Builder Preferences

Solution:

1) Open Reports Builder

2) Choose Tools -> Preferences

3) Go to Access tab and make sure that the checkbox next to 
   Access -> File
   is checked

4) Ensure that Access -> Database
   or
   Access -> File/database is not checked

Finally, you will get,

Thanks for reading my blog!

Sunday, April 1, 2018

Oracle Forms 10g/11g (web version) Keyboard Shortcut Key List

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt)

Some times, you may forget about the shortcut key when working in oracle forms.

To get the list at forms just press Ctrl + K, and you will get all the list.

Here i add in details.

Function	Shortcut Key

Show Shortcut Keys	*Ctrl + K*
Enter Query	*F11*
Execute Query	*Ctrl + F11*
Count Query	*F12*
Clear Block	F7
Clear Field	F5
Clear Form	F8
Clear Record	F6
Edit	*Ctrl + E*
Update Record	*Ctrl + U*
Insert Record	*Ctrl + Down*
Delete Record	*Ctrl + Up*
Commit	*Ctrl + S*
Duplicate Field	*Shift + F5*
Duplicate Record	*Shift + F6*
List of values	*Ctrl + L*
List Tab Pages	F2
Next Field	*Tab*
Next Record	*Down Arrow Key*
Next Primary	*Key Shift + F7*
Next Set of Records	*Shift + F8*
Previous Field	*Shift + Tab*
Previous Record	*Up Arrow Key*
Previous Block	*Shift+PageUp*
Scroll Down	*PageDown*
Scroll Up	*PageUp*
Up	*Up Arrow Key*
Down	*Down Arrow Key*
Print	*Ctrl + P*
Exit	F4
Help	*Ctrl + H*
Block Menu	*Ctrl + B*
Display Error	*Shift + Ctrl + E*

Thanks for reading the post and congratulation on your success.

Saturday, December 10, 2016

How to run Oracle Forms 10g with Java Web Start (Run Oracle Forms Application without Browser)

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

If you want to start oracle application without web browser then without third party solution, you have option to run application with Java Web Start(javaws.exe)

For Oracle Forms Application version 10g(10.1.2.3), it’s about few little steps of configuration.

Follow the bellow steps to configure

1.       You need to install JRE first then Java web start will automatically be installed.

2.       Then create a JNLP file at <oracle_dev/app_home>\j2ee\home\default-web-app

give name webstart_10gl with the following code

<jnlp spec="1.0+" codebase="http://localhost:7778/forms/java/">

<information>

    <title>Webstart Test Oracle Forms 10g</title>

    <vendor>hamid-oracle.blogspot.com</vendor>

    <homepage href="null"/>

    <description>Webstart Test Oracle Forms 10g</description>

</information>

<security>

    <all-permissions/>

</security>

<update check="timeout" policy="always"/>

<resources>

    <java version="1.6.0"/>

    <jar href="frmall.jar" download="eager" main="true"/>

<!—If you have more jar file add it bellow, all see a list bellow -->

       <jar href="icons.jar" download="eager" main="true"/>

       <jar href="frmwebutil.jar" download="eager" main="true"/>

       <jar href="looks-2.0.1.jar" download="eager" main="true"/>

       <jar href="jcalendar-1.3.2.jar" download="eager" main="true"/>

       <jar href="FJCalendar.jar" download="eager" main="true"/>

       <jar href="jacob.jar" download="eager" main="true"/>

</resources>

<applet-desc name="Webstart Test Oracle Forms 10g" main-class="oracle.forms.engine.Main" width="990" height="668">

    <param name="background" value="no"/>

    <param name="logo" value="no"/>

    <param name="serverApp" value="default"/>

    <param name="lookAndFeel" value="oracle"/>

    <param name="allow_debug" value="true"/>

    <param name="separateFrame" value="false"/>

    <param name="em_mode" value="1"/>

    <param name="latencyCheck" value="true"/>

    <param name="networkRetries" value="240"/>

    <param name="serverArgs" value="module=LOGIN.fmx useSDI=yes"/>

    <param name="serverURL" value="http:// localhost:7778/forms/frmservlet?ifcfs=http:// localhost:7778/forms/frmservlet?config=ENVTX"/>

    <param name="colorScheme" value="teal"/>

    <param name="splashScreen" value="no"/>

    <param name="dontTruncateTabs" value="true"/>

</applet-desc>

</jnlp>

3.

Now create a shortcut of the file (webstart_10gl) in the desktop and make sure it’s General Tab “Open with Java(TM) Web Start Launcher” same as bellow image.

4.       Now double click the shortcut and play with application.

Please not, all of your jar file must signed by same Signature.

Thanks for reading the post and congratulation on your success.

Tuesday, October 28, 2014

How to Read Image / Picture in Oracle Reports from File System ?

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

Today, i discuss an important issue, many of oracle developer spend hours and hours to make a reports to show image from file system, which is much complex.

From Now on, it will be easy and remain easy. :)

Follow the bellow steps.

Take a Formula column
Data Type Char
Length 500
Set READ FROM FILE property to YES
Set File Format to Image
Make the Image stored folder as Shared Folder

Example Code::

function CF_IMAGEFormula return Char is

filename VARCHAR2(200);
tiff_image_dir VARCHAR2(80) :='<PC_NAME>/emp_picture/'; --// Folder name should be shared for shared link.
out_file Text_IO.File_Type;
BEGIN

out_file :=Text_IO.Fopen(tiff_image_dir||:EMP_CODE||'.jpg', 'r'); -- r is read only AND EMP_CODE is the name of image.

filename := tiff_image_dir||:EMP_CODE||'.jpg';
return filename;

exception
when no_data_found then
RETURN tiff_image_dir||'blank.jpg';

when others then
if sqlcode=-302000 then
RETURN tiff_image_dir||'blank.jpg';
end if;

end;

You are Done :)
Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.

Sunday, April 27, 2014

How to Connect Oracle Database with Microsoft Access Database?

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt) but stuck in a place when you try to connect oracle database with MS Access database.

In short, you are trying to access MS Access data from Oracle DB.

Lets START…

This connectivity calls heterogeneous connectivity.

Important: The init-parameter GLOBAL_NAMES should have value FALSE. Check this parameter first before continuing the procedure.

In this example, I uses,

Database Name: TESTDB

OS User :Administrator

OS password :admin123

Setp 1 – Create Database Link via system DNS

Important: use 32-bit odbc driver for 32-version of oracle database and 64-bit odbc driver for 64-bit oracle database.

A 64-bit version of the Microsoft Windows operating system includes the following versions of the

Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):

>> The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

>> The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

if odbc driver not found on the odbc list then click at C:\Windows\SysWOW64\odbcad32.exe

(32-bit) for 64-bit download link are

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255

On the Oracle server start the ODBC Data Source Administrator. This can be done by using the run command: go to start/run and type odbcad32 and press enter.
In the ODBC Data Source Administrator window go to the System DSN tab and click on Add...
Choose in the Create New Data Source window the Microsoft Access Driver (*.mdb) and click on Finish.
In the ODBC Microsoft Access Setup window enter the data source name (e.g. TESTDB), the description (e.g. Test database) and select the Access database

If the Access database is on the same machine as Oracle is running, you can ignore step 1.5 and step 2!

If the Access database is on another machine in the network, you should use UNC-path notation. In the Map Network Drive window, leave the drive-letter on (none) and select via the UNC-path (e.g. \\192.168.100.10\HAMS_2013\HAMS_2013.mdb) the Access database. Finish the creation of the ODBC Link and close all the ODBC windows.

Step 2 Create Network ID

In order to perform a good connection to the Access database on another machine, you need to follow the following steps:

Create on the network and user id (e.g. TestDbAdmin) and give this UID read rights on the location of the Access files. NOTE: use the appropriate rights, this depends on the actions you want to take on the Access database.
Place this user, TestDbAdmin, in the ORA_DBA group on the Oracle server.

If you want to use Administrator user account. Go to windows service. Change the Database and TNS service Log On As administrator.

Right click on a services >> go properties >> go Log On and use this account.

Restart both the services.

Step 3 Create the Oracle TestDb listener (Oracle HS)

Important: Oracle Database Version 10g (known as inithsodbc.ora), Version 11g (known as initdg4odbc.ora)

Ø 10g file location: ORACLE_HOME\hs\admin\inithsodbc.ora

Ø 11g file location: ORACLE_HOME\hs\admin\ initdg4odbc.ora

Open the file at notepad and, modify the HS init parameters

HS_FDS_CONNECT_INFO = <odbc data_source_name>

HS_FDS_TRACE_LEVEL = <trace_level>

HS_FDS_CONNECT_INFO = TESTDB ( created at setp 1)

HS_FDS_TRACE_LEVEL = OFF

DATABASE LISTNER Configuration

Open the file listener.ora (%oracle_home%/network/admin) and add the following text, save and close the file (e.g. 11g database listener)

Original configuration

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = C:\Oracle\app\Administrator\product\11.2.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

ADR_BASE_LISTENER = C:\Oracle\app\Administrator

Modified Configuration

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = C:\Oracle\app\Administrator\product\11.2.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")

)

(SID_DESC =

(SID_NAME = dg4odbc)

(ORACLE_HOME = C:\Oracle\app\Administrator\product\11.2.0\dbhome_1)

(PROGRAM = dg4odbc)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

ADR_BASE_LISTENER = C:\Oracle\app\Administrator

Stop and start the listener service or from the command line:
C:\> lsnrctl stop
C:\> lsnrctl start

DATABASE TNSNAMES Configuration

Open the file tnsnames.ora (%oracle_home%/network/admin) and add the following text, save and close the file.

TESTDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost) (PORT = 1521)

)

(CONNECT_DATA =

(SID = dg4odbc)

)

(HS=OK)

)

Final Step- Create Oracle Database Link to TESTDB

Connect to database as SYS user or any user having create database link privilege.

CREATE PUBLIC DATABASE LINK “TESTDB”
CONNECT TO "Administrator"      --- OS user name
IDENTIFIED BY "admin123"           --- OS password
USING 'TESTDB';

Test the Link

select * from dual@"TESTDB";
If you got a number of rows back, you're done!
Reference.
### http://adf.ly/tm6Da
### http://adf.ly/tm6NA
Metalink Note

1. Document 1195583.1

2. Document 1475507.1

3. Document 234517.1

If it helps, leave your message.

Praise to Almighty Allah(swt).

Fi amanillah

Pages

Sunday, August 23, 2020

REP-1060: Reports Builder database tables have not been installed.

REP-1060: Report Builder database tables have not been installed. ORA-00942: table or view does not exist. Report Builder tables may not be installed in the database.

Sunday, April 1, 2018

Oracle Forms 10g/11g (web version) Keyboard Shortcut Key List

Hope you are well with the grace of Almighty Allah (swt)

Some times, you may forget about the shortcut key when working in oracle forms.

To get the list at forms just press Ctrl + K, and you will get all the list.

Here i add in details.

Function

Thanks for reading the post and congratulation on your success.

Saturday, December 10, 2016

How to run Oracle Forms 10g with Java Web Start (Run Oracle Forms Application without Browser)

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

Tuesday, October 28, 2014

How to Read Image / Picture in Oracle Reports from File System ?

Sunday, April 27, 2014

How to Connect Oracle Database with Microsoft Access Database?