Check duplicate item in block item.

When you want to create a lov with use where condition

Just use property plate of lov.

Use trigger against:

Lov with item;

Trigger name : when-mouse-doubleclick with item Level trigger;

Syntax: if show_lov(‘lov_name’) then

If dup_detail_check(‘block_name.item_name’)=1 then

Msgbox(‘duplicate value’);

Clear_record;

End if;

End if;



POST-CHANGE trigger:


SELECT FIRST_NAME INTO :TEACHERS.FIRST_NAME
FROM TEACHERS
WHERE EMPLOYEE_ID = :TEACHERS.EMPLOYEE_ID;

EXCEPTION

WHEN OTHERS THEN :TEACHERS.FIRST_NAME := NULL;

Read More

Format your pendrive or any others portable drive.

অনেক সময় মোবাইল ফোনের ক্ষুদ্র মেমোরি কার্ড ফরম্যাট হতে চায় না। কয়েকটি নিয়মে ফরম্যাট করা যায়। ফোনসেটে সব চেষ্টা বিফল হওয়ার পর যদি কম্পিউটারে Computer/Manage থেকেও ফরম্যাট করা না যায়, তবে উইন্ডোজের কমান্ড প্রম্পট থেকে কাজটি করা যায়। তবে ফরম্যাট করার সময় মেমোরি কার্ড থেকে যদি Data error cyclic redundancy check বার্তা দেখায়, তাহলে কমান্ড প্রম্পট থেকে আবার ফরম্যাট করা যাবে না।
মেমোরি কার্ডকে কার্ড রিডারে ঢুকিয়ে কম্পিউটারে ইউএসবি পোর্টে সংযুক্ত করুন। এবার Run-এ cmd লিখে এন্টার করুন। কালো পর্দা এলে diskpart লিখে এন্টার করুন। ডিস্ক পার্টের নতুন উইন্ডো খুললে সেখানে list disk লিখে আবার এন্টার করতে হবে। এবার হার্ডডিস্ক এবং অন্য যেসব ডিস্ক ড্রাইভ কম্পিউটারে যুক্ত আছে, সেসবের তালিকা দেখা যাবে। সাধারণত হার্ডডিস্ক প্রথমে থাকে এবং 0 থেকে পরবর্তী যতগুলো ডিস্ক কম্পিউটারে সংযুক্ত থাকবে, সেই হিসাবে নম্বর দেখাবে। কার্ডের জন্য যে নম্বর দেখায়, সেটি দেখে নিয়ে পরের কমান্ডে তা লিখে দিতে হবে। কার্ডের নম্বর যদি 1 হয়, এখানে select disk 1 লিখে এন্টার করুন। ফলে যে ডিস্ক নির্বাচন করবেন, সেটির জন্য disk 1 is now selected বার্তা আসবে। পরের বার Clean লিখে এন্টার করুন। এবার create partition primary লিখে এন্টার করুন। পরের বার format fs=fat 32 quick লিখে আবার এন্টার করুন। ফরম্যাট হওয়ার জন্য কিছুক্ষণ সময় নেবে। কাজটি শেষ হলে exit লিখে আবার এন্টার করতে হবে। ফরম্যাট হলে ফোনে ঢুকিয়ে নিয়ে কার্ডটি আবার ফরম্যাট করে নেবেন। একই নিয়মে যে পেনড্রাইভ এবং ইউএসবি ড্রাইভ ফরম্যাট হয় না, সেটিও ফরম্যাট করা যাবে। 

Read More

Having prob installing Oracle 10g in windows XP 32-bit

some link address to help for this<
1. http://students.heinz.cmu.edu/docs/Oracle_10g_Installation.pdf



.

Read More

How you can connect oracle database to Microsoft access database.

How to Connect Oracle Database with Microsoft Access Database?

My first post for oracle developer.

when you want to  try  connect oracle database with MS Access database.

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

Lets START GO ON…

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

1. 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.
2. In the ODBC Data Source Administrator window go to the System DSN tab and click on Add...
3. Choose in the Create New Data Source window the Microsoft Access Driver (*.mdb) and click on Finish.
4. 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
1. If the Access database is on the same machine as Oracle is running, you can ignore step 1.5 and step 2!
5. 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:

1. 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.
2. Place this user, TestDbAdmin, in the ORA_DBA group on the Oracle server.

OR

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>

TO

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://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_5005.htm
### http://www.orafaq.com/node/60
Metalink Note

1. Document 1195583.1

2. Document 1475507.1

3. Document 234517.1

If it gives you happiness, leave your message.

Read More

How to Install Oracle Developer Suite 10g on Windows Vista /windows 7 ?

How to Install Oracle Developer Suite 10g on Windows Vista /windows 7 ?

When you try to install Oracle Developer Suite on your windows Vista or Windows 7 PC but it’s failing giving an error message "Checking Operating system version must be 5.0, 5.1 or 5.2..... Actual 6.0 or 6.1 - Failed"

What will you do?

Don’t worry, simply follow the following steps, and it will works.

Before installation, right click on setup.exe then click properties, from the tab select compatibility and select windows xp service pac3/pac2 from compatibility mode settings.

Click ok…

And now try to install... it works simply.

Read More

How to Read Image File at Oracle Forms 10g ?

How to Read Image File at Oracle Forms 10g ?

I heard and answered lot's of question. How i read image file from file system to Database in oracle forms 10g ?
Here is the solution.
First of all you have to configure webutil correctly. You need to configure formsweb.cfg, webutil.cfg
Attach the webutil.pll library at your forms. Make object group and subclass of webutil.pll
Now add a puss button to your form and write the following code at When-Button-Pressed trigger
--------------------------------------------

declare
 vfilename varchar2(300);
begin
 vfilename := client_get_file_name(file_filter => 'jpg(*.jpg,*.gif)|*.*');
 if vfilename is not null then
 client_image.read_image_file(vfilename,substr( vfilename,instr( vfilename, -1)),'COMPANY_INFO_MST.CIM_LOGO');
 client_image.write_image_file(vfilename,'','COMPANY_INFO_MST.CIM_LOGO'); 
 end if;
 
end;

-----------------------------------

set the following property of the image item.

image format: TIFF
sizing style: Adjust

Read More

Error FRM-92095: Oracle Initiator version too low

Today my topic is Error FRM-92095: Oracle Initiator version too low

Symptom:

After logging into application, system pop up below error message:

FRM-92095: Oracle Initiator version too low. Please install version 1.1.8.2 or higher

Cause:

The JRE version is not incompatible.

Why it comes/shows ? 

When you have installed JRE version which is incompatible with your oracle form version, then you will get the above message. For example, your form version is 10.1.2.3 or 10.0.1.2 and your installed JRE version is 1.7.xx.xx, in that case you will get the message.

Cause this form version isn't certified by oracle corporation.

How to solve this ?

Open the "Java Control Panel" window.
Click the Java tab, then the View... button.

This should open a Java Run time Environment Settings window with two tabs: User and System.
On User tab, under Run time Parameters, enter:

-Djava.vendor="Sun Microsystems Inc."

OR

-Djava.vendor="New Oracle"

click Ok. then Apply and Ok.

 

That's it. Close the  brower and java console and retry.

Read More