Home » Developer & Programmer » Forms » DESPERATE: FRM-40508
icon9.gif  DESPERATE: FRM-40508 [message #224374] Wed, 14 March 2007 02:10 Go to next message
yesitsmkdp
Messages: 1
Registered: March 2007
Location: philippines
Junior Member

so im making a very simple system.. i made a form that accepts information.. it does the whole thing like add, delete, edit etc. and then i made another form thats supposed to accept infos as well but the damn thing wont work. i mean, i did the whole commit, update_record, create_record.. everything right. BUT the damn thing wont save records. what should i do?

the error is FRM-40508. the shift+f1 gives me this:

INSERT INTO MHCS_STUDINFO(LN,FN,MN,ADDRESS,PHONEA,BDAY,GENDER,LEVEL,FNAME,FOCC,MNAME,MOCC,ENAME,ADDRESSB,PHONEB) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)

ORA-01747: invalid user.table.column, table.column, or column specification


please help me. im really lost with this thing. thank you.

ym: yesitsmkdp@yahoo.com
msn: m3gz@hotmail.com

Re: DESPERATE: FRM-40508 [message #224380 is a reply to message #224374] Wed, 14 March 2007 02:21 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Possible that in the INSERT statement are not indicated owner of table. Try to verify this, and if it is correct, You can use public synonyms to correct error.
Re: DESPERATE: FRM-40508 [message #224981 is a reply to message #224374] Fri, 16 March 2007 06:28 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
yesitsmkdp wrote on Wed, 14 March 2007 08:10
INSERT INTO MHCS_STUDINFO(LN,FN,MN,ADDRESS,PHONEA,BDAY,GENDER,LEVEL,FNAME,FOCC,MNAME,MOCC,ENAME,ADDRESSB,PHONEB) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)



LEVEL is a reserved word and should not be used as column name.
SQL> create table faq (id number, "LEVEL" number);

Table created.

SQL> insert into faq (id, level) values (1, 2);
insert into faq (id, level) values (1, 2)
                     *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification


So better watch your language next time, because it is not the FORM that "won't work"...
Previous Topic: to save last record and exit loop
Next Topic: Icons are not displaying at run time in 10G
Goto Forum:
  


Current Time: Wed Dec 07 05:02:43 CST 2016

Total time taken to generate the page: 0.16282 seconds