| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unable to insert data
Maybe you should try using the continuation character '-' at the end of =
each line...just a thought as I sip my first coffee of the day...
>>> renee_at_openwindows.com.au 01/23/01 11:45PM >>>
Hi,
For some non-obvious reason, one of my insert statements out of about 90 refuses to work. The error being "missing comma". I know for sure there is no missing comma or any other syntax error, as it follows exact syntax as all the other insert statements.
I have found though, that it only throws this error when the number of =
input
fields exceed a particular number, say 14. I have inserted tables that =
were
in excess of this, so its not that it can't insert more than 14. Even =
after
swapping around what fields it inserts it still throws an error when it =
has
in excess of 14 input fields. No matter how many lines I format it into,
the "missing comma" is thrown on the second line unless I place all of the
statement onto one line then it doesn't get executed (which is unexplainabl=
e
in itself). I have also tried removed trailing spaces also.
Either I'm missing something obvious or something weird is going on. Has anyone got any idea why, or how to overcome this problem.
Following is the sql:
SQL> insert into unsecured.TPROGRESSCERTIFICATES (PROGRESSCERTIFICATESID,
PAYMENTID, CONTRACTID, CERTIFICATENO, INVOICENO, AMOUNTAPPROVED, DATE_R,
CURRENTCONTRACTPRICE, VARIATIONS, NOW_DUE, THISRETENTION, PREVIOUSRETENTION=
,
PREVIOUSPAYMENTS, PPSPERCENT, EXPORTDATE)
2 select ID, PAYMENTID, CONTRACTID, CERTIFICATENO, INVOICENO,
AMOUNTAPPROVED, DATE_R, CURRENTCONTRACTPRICE, VARIATIONS, NOW_DUE,
THISRETENTION, PREVIOUSRETENTION, PREVIOUSPAYMENTS, PPSPERCENT, EXPORTDATE
3 from contract.TPROGRESSCERTIFICATES t
4 where t.paymentid IN (select paymentid from unsecured.tpayments);
select ID, PAYMENTID, CONTRACTID, CERTIFICATENO, INVOICENO, AMOUNTAPPROVED,=
DATE_R, CURRENTCONTRACTP
*
ERROR at line 2:
ORA-00917: missing comma
The above works if I take out any one of the insert fields (well it =
attempts
to insert it anyway, and then finds constraint error etc. if say primary =
key
is taken out)
Thankyou in advance for any assistance.
ren=E9e
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Renee Bonnett
INET: renee_at_openwindows.com.au=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 24 2001 - 06:51:32 CST
 |
 |