FRM-40508 : ORACLE error: unable to INSERT record [message #330989] |
Wed, 02 July 2008 01:15  |
|
hello all..
i got an error frm:40508 .
pls advice me to overcome this .
here s the code
declare
a number;
v_pass_word varchar2(10);
v_conf_paswd varchar2(10);
v_studname varchar2(10);
v_username varchar2(10);
v_dob date;
v_email varchar2(10);
v_phone varchar2(10);
begin
v_pass_word := :online_reg.pass_word;
v_conf_paswd:= :online_reg.confirm_password;
v_studname:= :online_reg.student_name;
v_username:= :online_reg.user_name;
v_dob:= :online_reg.dob;
v_email:= :online_reg.email_id;
v_phone:= :online_reg.phone;
if
v_studname is null
then
message('enter the student name');
elsif
v_username is null
then
message('enter the User name');
elsif
v_pass_word is null
then
message('enter password:');
elsif
v_conf_paswd is null
then
message('enter the confirm password:');
elsif v_dob is null
then
message('enter the DOB');
elsif
v_email is null
then
message('enter the Email Id');
elsif
v_phone is null
then
message('enter the Phone No');
elsif
v_pass_word=v_conf_paswd
then
insert into na
values(1);
commit;
else
a := show_alert('ALERT_INVALID');
go_item(v_conf_paswd);
end if;
exception
when others then
a := show_alert('ALERT_ERROR');
end;
thanks
seyed
|
|
|
|
|
|
|
|
|
|
|
|