OraFAQ Forum: Forms » insertiing record

Home » Developer & Programmer » Forms » insertiing record

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

insertiing record [message #116616]

Wed, 20 April 2005 22:41

orcl_dba
Messages: 84
Registered: March 2005

Member

hi i am unable to insert records in the database using forms 6i with oracle 9i ...

i dont know what is the prblem

i have a table that has 2 fiels category id and category name

here is the code for the inserting operation im using ....

eclare
catgid number;

catgname varchar2(20);

begin

catgid := :TXTCID;
catgname := :TXTCNAME;

insert into category values(:catgid,catgname);

end;

now it doesnt show any error but record is not inserted in the dataabse...

best regards.. to hyou thnx in ad vance

Report message to a moderator

Re: insertiing record [message #116620 is a reply to message #116616]

Wed, 20 April 2005 23:36

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

Senior Member
Account Moderator

Do you have a primary key on this table?

In which order are the fields in the table defined?

Report message to a moderator

Re: insertiing record [message #116622 is a reply to message #116620]

Wed, 20 April 2005 23:42

orcl_dba
Messages: 84
Registered: March 2005

Member

yeah.. i have primary key

category id is incremented like 1 ,2 ,3 ,4 etc but thre is no sequence..

so i have 5 records.. and i am giving values in this statement ..

as
6 , and anyother string..

still not been able to get things corrected..

thnx for you ..

Report message to a moderator