Forms :: FRM-40735 When Button Pressed Trigger Raised Unhandled Exception ORA-01843

Oct 30, 2013

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!

View 6 Replies


ADVERTISEMENT

Forms :: FRM-40735 / WHEN-BUTTON-PRESSED Trigger Raised Unhandled Exception

Aug 17, 2011

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?

View 5 Replies View Related

Forms :: FRM-40735 / WHEN-BUTTON-PRESSED Trigger Raised Unhandled Exception ORA-06502

Oct 3, 2013

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

View 1 Replies View Related

FRM 40735 - WHEN-BUTTON-PRESSED Trigger Raised Unhanded Exception ORA-305500?

May 8, 2007

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]...

View 1 Replies View Related

Forms :: FRM-40735 / ON-ERROR Trigger Raised Unhandled Exception

Dec 21, 2010

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.

View 3 Replies View Related

Forms :: Frm-40735 Pre-query Trigger Raised Unhandled Exception Ora-06502

Jun 17, 2013

When i select Filnumber(DEC99) and press QUERY button, i get error"frm-40735 pre-query trigger raised unhandled exception ora-06502".

View 1 Replies View Related

Forms :: FRM-40735 Or Error Trigger Raised Unhandled Exception ORA-03114

Jun 13, 2010

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

View 5 Replies View Related

Forms :: FRM 40735 Key-next-item Trigger Raised Unhandled Exception ORA 01722

Sep 2, 2011

im updating my program and i got a error message

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

View 3 Replies View Related

Forms :: Error - Trigger Raised Unhandled Exception ORA-6508

Jul 8, 2011

I am trying to build one custom 10g form from TEMPLATE.fmb. when i try to compile my form in desktop it is giving error as Error FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508.

View 1 Replies View Related

Forms :: ON-ERROR Trigger Raised Unhandled Exception ORA-06508

Jan 18, 2007

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

View 15 Replies View Related

Forms :: Ora-06511 - Cursor Already Open - Trigger Raised Unhandled Exception

Apr 13, 2012

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].....

View 3 Replies View Related

Forms :: Frm-40375 / When-validate-item Trigger Raised Unhandled Exception ORA-01403

Mar 6, 2011

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..

View 14 Replies View Related

SQL & PL/SQL :: Trigger Raised Unhandled Exception

Apr 27, 2013

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]........

View 10 Replies View Related

Forms :: ORA-305500 Exception On When-Button-Pressed Trigger?

Jun 20, 2005

why this exception is occuring .my code is below.

Procedure Edit_File
(v_linked_file in out file_link.linked_file%type,
v_copy_status in out file_link.copy_status%type,
i_ext in varchar2) is

[code]....

View 18 Replies View Related

SQL & PL/SQL :: FRM-40735 - On-error Trigger Raised Unhanded Exception Ora-06508?

Aug 7, 2012

when ever the developer connecting to database to generate froms or While trying to create inventory categories below error is appearing.

FRM-40735: On-error trigger raised unhandled exception ora-06508..

View 9 Replies View Related

Forms :: Post-INSERT TRIGGER Raised Unhandled Error

Feb 9, 2011

I am facing a post trigger problem.No error while compiling.

DECLARE
mYPACCT VARCHAR2(10);
mTRNNO NUMBER; mVNO NUMBER; mSR NUMBER; mNARRATION VARCHAR2(200); mCHCODE VARCHAR2(10); mPARTY VARCHAR2(200);
mBRAND VARCHAR2(200); mYARN VARCHAR2(200);
BEGIN
BEGIN
SELECT YPACCT INTO mYPACCT FROM CONFIG;
EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
END;

[code].....

View 7 Replies View Related

Forms :: Button Pressed Trigger

Jan 6, 2012

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

View 16 Replies View Related

Forms :: How To Skip Trigger Only When Button Is Pressed

Mar 9, 2013

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.

View 2 Replies View Related

Forms :: Any Method On WHEN-BUTTON-PRESSED Trigger

May 9, 2012

I have a form of a user feedback with SMS Sending. which I gave to my all clients when ever my any client enter a feedback they press send SMS button so I got SMS if they press the button 2 times I got 2 same sms and if press the button 3 times I got 3 same sms and so on I want to restrict them and allow them to send only 2 sms of that feedback.any method on WHEN-BUTTON-PRESSED Trigger.

View 7 Replies View Related

Forms :: WHEN-VALIDATE-ITEM Trigger Raise Unhandled Exception ORA-01422

Sep 15, 2011

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..

View 2 Replies View Related

Forms :: How To Copy Values From One Table To Another Using When-Button-Pressed Trigger

Feb 14, 2013

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.

View 16 Replies View Related

Forms :: FRM-21011 - PL/SQL Unhandled Exception ORA-306500

Dec 26, 2006

I am getting the follwoing error at the time of opening the application menu

FRM-21011: PL/SQL unhandled exception ORA-306500.

View 9 Replies View Related

Forms :: After Upgrading To 11g / FRM-21011 - PL/SQL Unhandled Exception ORA-06508

Mar 16, 2012

After our client upgraded to 11g database and application server, they are getting this error while trying to access another form from the option menu (The option menu is generated with a library, the values are taken from a database table). This issue occurs only in one particular scenerio, and only in on form, other forms with similar functionality and same structure are working perfectly fine. The error is written below.

FRM-21011: PL/SQL unhandled exception ORA-06508

I tried in my environment (10G), no error exist there.In 11G environment, I tried re-attaching a library in the form and compiling again, the error does not come after recompiliation. But the client can still see the error even after recompiling the form (after reattaching that particular library).I could find the below info on google:

FRM-21011: PL/SQL unhandled exception %s.
Cause: An unhandled exception occurred while executing a menu trigger.
Action: Examine the text of the exception in this message. If this indicates a cause,
correct it. If the problem persists, contact Oracle Support Services.
Level: 25
Trigger: None

I am using form builder 10G, will compiling the form using Form builder 11G?

View 4 Replies View Related

Forms :: Open PDF File When Button Pressed?

Dec 6, 2009

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?

View 5 Replies View Related

Forms :: 6i To Show Detail Block When Button Pressed?

Aug 16, 2011

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.

View 6 Replies View Related

Forms :: Implement Exception Handling In Exception Block Of A Trigger

Oct 10, 2011

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.

View 2 Replies View Related

Forms :: Display Checkbox Selected Records In One Column Of Form / When Push Button Is Pressed

Jul 2, 2011

how to display check box selected records in one column of form when push button is pressed.

View 1 Replies View Related

Forms :: Alert Cancel Button Gives Non Oracle Exception

Jan 20, 2011

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?

View 5 Replies View Related

Server Utilities :: Error - An Unhandled Win32 Exception Occurred In Ctxhx.exe

Mar 15, 2011

I have importing a dump file which is of size upto 6GB, its working fine. At the last step after the import of all the tables when it enables constraints , indexed and everything a pop-up window with the above mentioned error in the subject pops-up.

I am not able to mention the error exactly so find the screen shot as attachment.

View 4 Replies View Related

Forms :: Use RAISE FORM-FAILURE-TRIGGER In EXCEPTION?

Jun 12, 2012

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]...

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved