OraFAQ Forum: Forms » how to insert.................................

Home » Developer & Programmer » Forms » how to insert.................................

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

how to insert................................. [message #116559]

Wed, 20 April 2005 11:09

orcl_dba
Messages: 84
Registered: March 2005

Member

how to insert data through forms. i m very new to it and stuck up on a small problem

i have a table having 2 fields category id and category name..

on form 6i wih orcle 9i release 2 databsae..

i have 2 text boxes i which user enters the values for these 2 fiels..

now the code i use is here ..

declare
catgid number;

catgname varchar2(20);

begin

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

insert into category values(:TXTCID,:TXTCNAME);
insert into category values(:catgid,:catgname);

end;

i have used both ways to insert but it shows some unhandled exceptions like ..ora 000001 some thing like that

help me plz ..

also tell me how to update. .what is the phihlosphy of using a

colon before variable. i htink it is for displaying its values isint it ..
but when i use catgname, and catgid in insert clause with colon it gives error..

best regards

Report message to a moderator