Ошибка ora 305500

I have a piece of code which imports data from EXCEL to ORACLE forms.But after this I am getting the exception

FRM 40735:WHEN-BUTTON-PRESSED Trigger Raised unhandled Exception ORA — 305500

My Coding is below,
PROCEDURE PROC_IMPORT_EXCEL IS
—Cursor To Get The Number Of Columns Of the table
CURSOR c_get_table_columns IS
SELECT COUNT(ATC.TBLCLMNID) FROM APPLCTN_TABLE_COLUMN ATC

[code]…

I have a form which contains tabular layout which i can fill a text item with date format. I set the data type properties to «Date» with format mask «dd-mm-yyyy».When I click a «save» button, it will call a procedure to insert into table. But i’m getting this error message : «FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502»

I did some search on google and error 06502 means numeric or value error. But I don’t understand what caused my error. Is it at my text item’s properties?

I am trying to insert some values into a table from a form i get the below error;

which says not a valid month;

FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01843

after i do google i added the below one to the insert statement and again i receive the error;

to_date(to_char(sysdate,’dd/mm/yyyy’),’dd/mm/yyyy’)

My Insert Statement

insert into Invoice123
(Invoiceno, invdate, gross_tot, discount)
values
(nvl(INVOICEno(j),0),
to_date(to_char(invdate(j),’dd/mm/yyyy’),’dd/mm/yyyy’));
commit;

by which format we can achieve this!

I have Forms 6i, installed in a system at remote location with OS Windows 7. Previously the same was installed in Windows XP it was working fine. Now in Windows 7 also its working fine for most of the things, for some data loading options its not working and showing below shown error.

FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

I have got a form with 3 buttons and when these are pressed determine who is logged in, what role they are and if they are a certain role go to another block, if they are not that role flag up a message. I think I need to create a function in the database along the lines of —

create function user_has_role (p_user in varchar2 default user, p_role in varchar2)
return boolean
as
select * from dba_role_privs where p_user = GRANTED_ROLE;
end

in my form I have a button that updates a table and I have a pre-update trigger.

is it possible to skip the pre-update trigger only when the button is pressed.

I have two tables one is

1)create table abc(c_name varchar2(10),c_number number(6),c_loc varchar2(8)); —having values
2)create table temp(sname varchar2(10),sid number(4),address varchar2(10));—no having

and my question is how to insert a values into temp using when-button-pressed trigger based on abc table in oracle form.

I’ve a button on a form and I wrote a trigger when button pressed to open a pdf file and it worked fine this was my

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin(‘C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe Z:BUILTINS.pdf’,DDE.APP_MODE_NORMAL);
end;

The thing is this form is used by multiple clients and if a user has a different version of acrobat reader rather than version 8 this will not work how to do it to be uniform?

Is it possible to display the detail block (different canvas) in the master block canvas, but when finished entering data into master block and a button is pressed? And i want to use some conditions in the when-button-pressed trigger. based on that it should show different canvas.

simply speaking, my aim is to use the upper part of the screen to show master block and the lower part for a detail block from the different detail blocks based on condition checked in when-button-pressed trigger.

I have to implement exception handling in the exception block of a trigger, Quote:exception

when ora_java.java_error then
message( ‘Unable to call out to java, ‘ || ora_java.last_error );
ORA_JAVA.CLEAR_EXCEPTION;

when ORA_JAVA.EXCEPTION_THROWN then
ex := ORA_JAVA.LAST_EXCEPTION;
message( Exception_.toString(ex));
— lv_exception := Exception_.getMessage(ex);

I get an error for the line: ‘message( Exception_.toString(ex));’I have imported the java classes FException et IObject with their methods.

I have to create a Web Service Client, so I wonder if the paragraph Quote:when ORA_JAVA.EXCEPTION_THROWN then ex := ORA_ JAVA. LAST_ EXCEPTION; is mandatory.

i’ve created an alert with 2 buttons and the code for cancel button is as follows:

…
if alert_id = alert_button2
then
raise form_trigger_failure;
end if;
…

this code is in a pll and when called from a form it displays a non oracle exception message. How to do nothing when the user presses cancel on alert pop-up? apart from using null instead of raising the above exception?

My requirement, if there is no record in emp table when validate the EMP_NO_CHK text field, i need to set the focus on that field (EMP_NO_CHK) itself. But while execute the following code, I got error.chieve the task.

—EMP_NO_CHK_WHEN_VALIDATE_ITEM Trigger
————————————
Declare
cursor c is Select * from emp where Emp_no = :header.empno;
c1 emp%rowtype;
n NUMBER;

[code]…

I am using forms 10g developer suite, AIX in appl server.

When I run the form on my local drive through web I am getting error that,FRM-40735:ON-ERROR trigger raised unhandled exception ORA-06508.

My fmbs & fmxs are in e:fmb, libraries are in d:applicationlib.

FORMS_PATH in Registry is C:DevSuiteHome_1cgenf61admin;C:DevSuiteHome_1forms;e:fmb;d:applicationlib

I have set the same path in default.env also.What should I update, to run the form successfully.

I am in process of migrating Oracle 6i Forms to Oracle 10g Forms.

In 6i, the Form compiles and runs without any giving any error.

In 10g it does complie without any error but gives following Runtime Error Message —

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

i’m designing a DB_application where a user makes certain subject selections depending on what grades they have. so far ive made simple signin form as follows….

Create table Persons(
person_id number(8) constraint pk_Persons primary key,
person_pword varchar2(16) not null;

declare
user_id number(8);
user_pword varchar(16);
alert_button number;
begin

[code]…

now the next step… that SIGNED IN user is taken to a menu with links to select their topics or units. HOWEVER only a PARTICULAR link can be followed depending on what grade they’ve achieved in a NECESSARY UNIT for example to do advanced maths u need beginners maths = PASS. if = fail then user cannot proceed. heres my sql as well as the trigger ive made an attempt at…

Create table Grades(
grade_code number constraint pk_Grades primary key,
grade varchar(4) check (result in (‘fail’,’pass’)),
person_id number,
unit_code number,
CONSTRAINT fk_Persons FOREIGN KEY (person_id) REFERENCES Persons (person_id),

[code]…

i know my second trigger is poorly designed and lacking.

I have a form (StaffDetail) with three different blcoks. One of them is an Application Assignment block which consists of nothing but Assignment Type, Staff (Name), Last Updated By and Last Updated Date.. The Assignment Type and Staff has LOVs assigned to them individually.. Assignment type lets me pick all different types except for Project Manager. As soon as I select this option, i get the following error :

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception…

This does not even let me select any other Assignment type, then i have to go close all sessions and come back into the same screen.

Also, this form was first created and tested on the development environment and later moved to QA environment. All selections work in the development environment.. I checked for the roles in QA for individual Users..

I have Written this code in WHEN-VALIDATE-ITEM-TRIGGER on PO_DATE field

if not( :PO_HEADER.PO_DATE IS NOT NULL ) then
:po_header.po_date := trunc(sysdate);
end if;
if trunc(:PO_HEADER.PO_DATE)>trunc(sysdate) then
displayerror.errmsg(‘PO date cannot be future date!’);

[code]…

when i am navigating through po_DATE field in the form its showing the error that

WHEN-VALIDATE-ITEM-TRIGGER raised unhandled exception.

I am using database 10g and Form 6i. We are working under client server technology. Frequently we are receiving the following error to every user at randomly when they are idle few seconds/minutes.

FRM-40735 or error trigger raised unhandled exception ora-03114

im updating my program and i got a error message

FRM 40735 key-next-item trigger raised unhandled exception ORA 01722

I getting a error Ora-06511 when-new-item-instance trigger raised unhandled exception.

below is the coding for the trigger when-new-item-instance : where the cursor is open? how to close it?

if :blk_master.action_status = ‘A’ then
declare
doc_slno number;

[Code]…..

frm-40375: when-validate-item trigger raised unhandled exception ORA-01403.

i put a new column which is the birth date and i made a new procedure with regards to the age level for the Plan. and when i run the program, theres an error..

I have a situation where one form calls another. I am opening the other form(say B) using the below code.

declare
temp_form formmodule;
begin
temp_form := FIND_FORM (‘D:RSSQ2TestingpurposesMODULE3_MULTIPLE’);

[code]…

On Form B there is an Exit button on click of which it closes the Form B and returns to Form A

begin
close_form(‘MODULE3_MULTIPLE’) ;
end;

In my scenario on Exit from FORM B i need to enable a button on FORM A.I am not able to capture the trigger that fires when I Press the Exit

I am writing a trigger TR_EMP on a table EMP which has columns EMP_ID, EMP_NAME, ALT_EMP_ID.

Now I am updating ALT_EMP_ID for an EMP_ID(PK) which is unique.

If ALT_EMP_ID is null
then
:new.ALT_EMP_ID = l_alt_emp_id;
end if;

As this ALT_EMP_ID is unique, same ID shouldn’t be inserted again here. When data being inserted with 2 different sessions for 2 different EMP_ID there is a possible chance of inserting same ALT_EMP_ID for both which results in Unique error. I need to handle this exception. DUP_VAL_ON_INDEX or OTHERS Execption not able to handle this.

I created my login as you have first to fill the form then login, unfortunately i am getting when i press the button as error frm-40735: when-button-pressed trigger raised unhandled exception ora-04063.

these are the code after fill the form

declare
sex varchar2(10);
emid varchar2(30);
begin
if :signup.gender = 1 then
sex := ‘Male’;
elsif :signup.gender =2 then
sex := ‘Female’;
[code]……..