shot in the dark - could it have to do with a too long
sql script? have you tried cutting the file into two
pieces?
fwiw,
yosi
> -----Original Message-----
> From: Renee Bonnett [mailto:renee_at_openwindows.com.au]
> Sent: Tuesday, January 23, 2001 11:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to insert data
>=20
>=20
> Hi,
>=20
> For some non-obvious reason, one of my insert statements out=20
> of about 90
> refuses to work. The error being "missing comma". I know for=20
> sure there is
> no missing comma or any other syntax error, as it follows=20
> exact syntax as
> all the other insert statements.
>=20
> I have found though, that it only throws this error when the=20
> number of input
> fields exceed a particular number, say 14. I have inserted=20
> tables that were
> in excess of this, so its not that it can't insert more than=20
> 14. Even after
> swapping around what fields it inserts it still throws an=20
> error when it has
> in excess of 14 input fields. No matter how many lines I=20
> format it into,
> the "missing comma" is thrown on the second line unless I=20
> place all of the
> statement onto one line then it doesn't get executed (which=20
> is unexplainable
> in itself). I have also tried removed trailing spaces also.
>=20
> Either I'm missing something obvious or something weird is=20
> going on. Has
> anyone got any idea why, or how to overcome this problem.
>=20
> Following is the sql:
>=20
> SQL> insert into unsecured.TPROGRESSCERTIFICATES=20
> (PROGRESSCERTIFICATESID,
> PAYMENTID, CONTRACTID, CERTIFICATENO, INVOICENO,=20
> AMOUNTAPPROVED, DATE_R,
> CURRENTCONTRACTPRICE, VARIATIONS, NOW_DUE, THISRETENTION,=20
> PREVIOUSRETENTION,
> PREVIOUSPAYMENTS, PPSPERCENT, EXPORTDATE)
> 2 select ID, PAYMENTID, CONTRACTID, CERTIFICATENO, INVOICENO,
> AMOUNTAPPROVED, DATE_R, CURRENTCONTRACTPRICE, VARIATIONS, NOW_DUE,
> THISRETENTION, PREVIOUSRETENTION, PREVIOUSPAYMENTS,=20
> PPSPERCENT, EXPORTDATE
> 3 from contract.TPROGRESSCERTIFICATES t
> 4 where t.paymentid IN (select paymentid from =
unsecured.tpayments);
> select ID, PAYMENTID, CONTRACTID, CERTIFICATENO, INVOICENO,=20
> AMOUNTAPPROVED,
> DATE_R, CURRENTCONTRACTP
> *
> ERROR at line 2:
> ORA-00917: missing comma
>=20
> The above works if I take out any one of the insert fields=20
> (well it attempts
> to insert it anyway, and then finds constraint error etc. if=20
> say primary key
> is taken out)
>=20
> Thankyou in advance for any assistance.
>=20
> ren=E9e
>=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=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
Received on Wed Jan 24 2001 - 10:31:05 CST
