Forms :: ORACLE ERROR Unable To Read List Of Values
Sep 28, 2010
We have recently shifted our database from 10G to 11G and after the intial hickups most of the thinghs have stablised. We had changed system by Alter System command so that database does not have case sensevity problem and with that all the reports from the forams have also stabilied However some of the forms are failing with the above error ORACLE ERROR Unable to read list of values
These form are running fine with users having DBA privelege. However other users this is failing.
We have also checked that with users not having DBA privelege we are able to read the data in the table within the form also. The query in the record group is very simple
"SELECT CODE,SHORTDESC FROM GENCODES WHERE CODETYPE='BS' AND CODE <> '00'"
All these forms were fine previously when database was on 10g.
Moreover there are many other fields where list of values are there and allthose are ruing fine.
I have also checked datatype and length in query as well as fields on the form
1.display_item (primary key) 2-list_item (foreign key) / / dynamic list :this is the cause of the error 3-lis_item (foreign key) / / dynamic list 4-text_item 5-button (insert commit)
when I click the button, an error is displayed:
FRM-40508: ORACLE error: unable to INSERT record.in detail: ora-02291 integrity constraint Violated - parent key not found
Note:
-the elements of two lists already exist in the parent table!!
I have the search screen in my form so after searching if i select the row by using the button it will navigate the first tab page that is "gas" screen here if i tried to change the value like update and save the form it is not allowing me to update the value raising the error message "oracle unable to insert the record". if i see the "display error" in menu it is having the select statement with error "unique key violation error ora-00001".
I have developed one sample form using oracle Internet developer Suite 10g. It has two fields.
1.all employees(I set as combobox) 2.members (i set as text box)
In runtime all employees column has all the employee name displayed . If i select the employee name one by one it added into the members textbox. How to solve that issue?
I have made one LOV for vendor_names. On form level i want that when the user will enter a particular alphabet in a textbox assigned with LOV, the list should popup with only those elements starting with that particular alphabet. I have written the following code in the query of LOV wizard
query:
select distinct(bpt_ven_nm),bpt_ven_cd from bill_hdr1_tab where bpt_ven_nm like ('enter.vendr_nm'||'%') order by bpt_ven_nm
Wherin 'Enter' is the name of block and 'vendr_nm' is field name.
But its getting unsuccesfull. Any alternate way to get this result.
I have one drop down list box from which i want to do add or copy the values chosen from the list to another text box and then using this copied values ,i will pass them as parameters to run report.This list is getting populated using recordgroup and then what ever user chooses , it will be added to the another text box with space or delimiter.
In my forms(version 9i), list item values showing with ALT + DOWN key combination but I want to change it to only DOWN key.I search this combination in FMRWEB.RES file but there isn't any entry of ALT + DOWN.
I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.
I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".
I have Select list itemS based on Lookup tables. When the form in Edit mode, I want to prevent the end user from changing the value of these Select list items. How can I accomplish this ??? **If I change the type of the item to Display only, then it will show the returned value of the Select list.
in my case both are not working as i am using oracle forms 11g with oracle weblogic application server and attached the required .pll libraries in the form but no success yet.
when i click on the button form is hanged and on the server machie the following message appears " Close this form". when i close this it close the form applet session completely.
I want to read and write data from a file in | seprated mode. file READ and WRITE using Oracle Forms6i. I have a knowledge of file handling in C++ but not use it in Oracel Form before this.
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
I am getting the same error on a form I am setting up under version 10.1.2 Form Builder. But when I press Shift-F1 I get a Getting Started with Internet Explorer popup. I am running the form under OAS. I have a parent/child relationship between 2 tables that I query on the form.
I am trying to create standby with oracle 10g R2 from Solaris 5.10 (sun ultrasparc X86-64 bit) to Solaris 5.10(Intel Xeon 64 bit). All the mount points are the same as primary server. All the data files are at location as specified in control file. I created standby control file from primary. All the control files are at location specified in pfile.
When I am trying to mount database I am getting following error.
ORA-00202: control file: '/oracle/BP1/ctl1.dbf' ORA-27047: unable to read the header block of file ORA-205 signalled during: alter database mount...
I try to open database with trace file also but got following error..
ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/oracle/BP1/sapdata1/system_1/system.data1' ORA-27047: unable to read the header block of file
I'm facing this error: FRM-91120: Internal Error: Unable to load NLS character set
when I try to run command runform50.
I've set my NLS_LANG to American_America.WE8ISO8859P1 (which the the same as my DB), I've set the ORA_NLS33, ORA_NLS32 and ORA_NLS vars to /usr/oracle/OraHOme1/ocommon/nls/admin/data I've set the NLSPATH to /usr/lib/nls/msg/%L/%N
If I run runform50 command without any options, it shows me the help file, so I think it is correctly installed..
I guess the same thing as you're probably thinking .. that I'm missing some charset ... but where ? they should be in ocommon/nls dir ? if so, I've already installed pretty much everything of the developer2000 cd
I have a database in access 2003 with the empno,empname and photo (bounded image). Using queries and an ODBC connection I have inserted the table into Oracle 8i (8.1.7). When I try to read the data using reports I get 'REP-1818 Unable to read data in image format.' error for the photo field.
I'm running the following and getting access denied errors.What do I need to do to make the recovery files available of the duplicate host?I cataloged the backupsets at the network path of where they are, I don't have space on the drive for the backupset and the restored database once it's done.
*Results filtered for length on duplicate lines
RMAN> DUPLICATE TARGET DATABASE TO Test 2> DEVICE TYPE DISK PFILE='D:ORACLEORA102DATABASEINITTEST.ORA'; Starting Duplicate Db at 02-AUG-13 released channel: ORA_AUX_DISK_1 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=155 devtype=DISK
contents of Memory Script:
{ set until scn 2875467028; set newname for clone datafile 1 to new; set newname for clone datafile 2 to new; ...TRIMMED
I'm having a problem with null values. I want to display old student in a display item if subjects text item has records. Otherwise, display new student if it has null values. This is the code that i tried so far..
IF :block2.subjects IS NULL THEN :block3.type := 'NEW STUDENT'; ELSE :block3.type := 'OLD STUDENT'; END IF;
My job is running at 2 am and that time no application user is connected. Even though, my exp utility shows error on 3 tables (2 are temp tables), everyday. But when expdp is running without error, which was scheduled at 4 am.
Below are the error -
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. . exporting table DW_TEST_MOTOR EXP-00056: ORACLE error 1466 encountered ORA-01466: unable to read data - table definition has changed
On Oracle 11gr2 DB Prod DB client error log gives error "Txxnx_AxSxNERGY service terminated unexpectedly" and it has done this 25 time(s) but from DB size in alert.log i can find only "ORA-1652: unable to extend temp segment by 128 in tablespace TIVOLIORTEMPTS" error.
After increasing table space size it starts working fine but i am not sure whether Table space was a reason for service termination or network issue i can not find any error in listener.log file .