OraFAQ Forum: Forms » problem while inserting in forms 10g

Home » Developer & Programmer » Forms » problem while inserting in forms 10g

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

problem while inserting in forms 10g [message #144762]

Fri, 28 October 2005 02:42

nselangovan
Messages: 11
Registered: August 2005

Junior Member

sir/madam i am using oracle 10G forms while i am tring to insert
values it
shows ora -01401 inserted too large value.

my table desc is

 tools
 indent_no varchar2(8),
 indent_slno number(3),
 sup_code varchar2(3),

my coding is insert into

tools(indent_no,indent_slno,sup_code)values(:tools.indent_no,:tools1.indent
_no,:tools1.sup_code);

i used two different blocks.

but i got inserted using sql prompt.
i want insert through forms.plz help.

thanks

by elangovan s

[Updated on: Sun, 30 October 2005 21:24] by Moderator

Report message to a moderator

Re: problem while inserting in forms 10g [message #144988 is a reply to message #144762]

Sun, 30 October 2005 21:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In your form, how big are the fields:
tools.indent_no,
tools1.indent_no, and
tools1.sup_code?

I think that your form fields are bigger than your database fields. IMO the form fields should always be the same size as the fields in the database.

David

Report message to a moderator

Previous Topic:	form trigger
Next Topic:	LOV does not display

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:46:13 CDT 2024