Home » Developer & Programmer » Forms » FRM-40508 : ORACLE error: unable to INSERT record (oracle 9.2.0.1 forms6i windows xp)
FRM-40508 : ORACLE error: unable to INSERT record [message #330989] Wed, 02 July 2008 01:15 Go to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

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
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #330992 is a reply to message #330989] Wed, 02 July 2008 01:28 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Check the value which you are trying to insert in your database table column and Check the length of the column and your value.
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #330993 is a reply to message #330989] Wed, 02 July 2008 01:32 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

go to the Forms 'Help' menu and select 'Show error'
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #330997 is a reply to message #330989] Wed, 02 July 2008 01:44 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

thanks for your replies. .

i checked the table
its null
no primary keys
no previlege problems
i hope there is no problems with tablespace. ..


Re: FRM-40508 : ORACLE error: unable to INSERT record [message #331008 is a reply to message #330997] Wed, 02 July 2008 02:37 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

post the table script
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #331010 is a reply to message #330989] Wed, 02 July 2008 02:41 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hey wency

if u meant table na
create table na(id number)
values(1);
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #331015 is a reply to message #331010] Wed, 02 July 2008 02:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
This is NOT a valid table-creation script
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #331035 is a reply to message #330989] Wed, 02 July 2008 03:39 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

im sorry it was by mistake ..



create table na(id number);
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #331257 is a reply to message #331035] Wed, 02 July 2008 15:24 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would you mind to PROPERLY format code you posted in your first message? True, you did use [code] tags, but code is completely unreadable. An utter mess.

This is what Oracle says about error code:
Oracle
FRM-40508: ORACLE error: unable to INSERT record.

Cause:  A fatal error occurred while trying to insert a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.

Action:  Contact your DBA.

Level:  >25
Re: FRM-40508 : ORACLE error: unable to INSERT record [message #338156 is a reply to message #331257] Mon, 04 August 2008 00:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: problem in working with on_error trigger
Next Topic: Delete problem in master detail form
Goto Forum:
  


Current Time: Fri Dec 09 11:45:01 CST 2016

Total time taken to generate the page: 0.07149 seconds