FRM-40735: WHEN-BUTTON_PRESSED trigger raised unhandled exception
eg:
WHEN-BUTTON_PRESSED trigger raised unhandled exception ORA-00001.You will have to look for causes of this Oracle error message, in our example it's a UNIQUE KEY violation.
When you need more information, you can press Shift+F1 in order to see the "real" error code.
You can also go via the help menu and choose Show Last Error
Welcome to our forum for Oracle error: FRM-40735 Add your own message
Please press SHIFT-F1 to see the last error message, it will tell you the real problem
WHEN BUTTON PRESSED trigger raised unhandled exception ORA 01476
when i run a form in my PC, it works properly but the same one in another PC it shows the following error-
FRM-40735 when-button-pressed trigger raised unhandled exceptions over oRA-01427
Check your data, and do not divide by zero.
FRM-40735: D0_BTN2 trigger raised unhandled exception ORA-01722 any ideas on a fix ?
Check your code if this is handled correctly
password works fine,but when end user runs the form using his id it gives form-40735 error
what is the cause
Check the code and see if you can catch the invalid number, or rewrite the code so it is handled correctly
ON-ERROR trigger raised unhandled exception ORA-06508
Please press SHIFT-F1 to see the last error message, it will tell you the real problem
any help is highly appriciated.
Harshal
Please press SHIFT-F1 to see the last error message, it will tell you the real problem
then this error is occured
" ora-30 frm-40735 key_next_item trigger raised unhandled exception ora-00904 "
why and what you mean by that
please help..
Somewhere in your code you have an invalid syntax.
It doesn't need to be inside the forms code, also check for database triggers which call procedures/functions which contain dynamic sql
But when i click on the button it gives the exception
FRM-40735: WHEN-BUTTON_PRESSED trigger raised unhandled exception ORA-06508
Kindly help me out to solve this problem. I will be very much thankful to you.... __.____._
Ora-06508 is a catch all error message and is usually followed by another error with more information.
This can be a privilege problem, or a misconfiguration for the file_open_dialog procedure.
we have an application which is built using forms 6i.
in this when iam trying to login, its poping this error
"FRM-WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-03114"
i have valid user id and password. in other pc's its working, only in my machine its not working.
Goto the help menu and choose 'Last Error', or press shift+F1
There is a pl/sql error, but need more detail, which is normally provided by the 'Last Error'
Go_block('SEL_UEXT_FIELDS');
delete_record;
execute_query;
commit;
am i missing something here please help,this is the last error i get when pressing shift+F1
If the block is not based on the GC_UEXT_REPS table, there might be a trigger that is firing.
If the block is based on the table, make sure you supply all the values.
If you get a value, you might want to check for a trigger, of other code that clears the content of the field/column
FRM-40735 when-button-pressed trigger raised unhandled exceptions over oRA-01427
Check your code. Somewhere more than 1 row as fetched, while a select into can only fetch 1 row
Check the sizing of your rollback/undo segments.
There is not enough space left to extend the (UNDO) tablespace, either because the disk is full (when autoextend is turned on), or you reached the maximum size of the datafile(s).
I have made a trigger to enter the details from a single form in two tables but its not working properly. Clicking on the button gives the above error.
The code is
DECLARE
CNT NUMBER(5);
TEMP NUMBER(2);
begin
SELECT EMP_ID INTO CNT FROM TBL_CRM_EMP WHERE EMP_ID=TBL_CRM_EMP.EMP_ID;
IF CNT IS NOT NULL THEN
TEMP:=SHOW_ALERT('ALERT');
ELSE
INSERT INTO TBL_CRM_EMP VALUES (:TBL_CRM_EMP.EMP_ID, :TBL_CRM_EMP.EMP_NAME, :TBL_CRM_EMP.EMP_ADDRESS, :TBL_CRM_EMP.DATE_BIRTH, :TBL_CRM_EMP.DATE_JOINING);
INSERT INTO TBL_EMP_SALARY VALUES(:TBL_CRM_EMP.EMP_ID, :TBL_CRM_EMP.SAL_MON, :TBL_CRM_EMP.SAL_AMT, 1);
END IF;
end;
AM i missing something?? thanks in advance.
Following select will probably return more than 1 row:
SELECT EMP_ID INTO CNT FROM TBL_CRM_EMP WHERE
EMP_ID=TBL_CRM_EMP.EMP_ID;
It seems like you forgot the count(emp_id)?
Or did you mean (with the colon):
SELECT EMP_ID INTO CNT FROM TBL_CRM_EMP WHERE
:EMP_ID=TBL_CRM_EMP.EMP_ID;
Enter your message can you help me with this error FRM-40735: WHEN-BUTTON-PRESSED trigger
raised unhandled exception ORA-01422
You are doing a select col into field, but the select returns more than 1 row
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.