OraFAQ Forum: Forms » ora-40735

Home » Developer & Programmer » Forms » ora-40735

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-40735 [message #669153]

Thu, 05 April 2018 09:27

chitz123
Messages: 1
Registered: April 2018

Junior Member

0
down vote
favorite
this is my code i wrote for when_mouse_click trigger on a button

declare
a varchar2(20) := '&book_no';
b varchar2(20) := '&book_name';
c varchar2(20) := '&price';
d number(4) := '&no_of_books';
begin
insert into book
values (a,b,c,d);
EXCEPTION
when VALUE_ERROR then
dbms_output.put_line('VALUE_ERROR exception raised');
end;
it compiled sucessfully but when i run it says frm-40735:when mouse click trigger raised unhandled exception ora-06502 but when i display error it says "no errors encountered recntly " at the same time i run this query on my sqlplus it runs sucessfully. please give me a solution soon it wil b very grateful to you .

Report message to a moderator

Re: ora-40735 [message #669155 is a reply to message #669153]

Thu, 05 April 2018 09:39

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

'&' is used to represent substitution variables in sqlplus.
In forms it's just data with no special meaning.
So this:

d number(4) := '&no_of_books';

is always going to error out. You can't store those characters in a number variable.

Also the exception handler won't catch that since it's in the declare section.

Report message to a moderator

Re: ora-40735 [message #669168 is a reply to message #669153]

Fri, 06 April 2018 08:07

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

And dbms_output is useless in Forms as you will never see he output.
And inserting into a table with values clause without naming the columns is sloppy and dangerous. What happens when the table definition changes?

Report message to a moderator

Previous Topic:	Open word document saved in database using forms 6i
Next Topic:	Updating data Without Update command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 27 13:06:43 CDT 2023