Possible Oracle bug - spot the mistake

[Quoted] Hi all.

I have a wierd problem.

I have an insert statement that looks like this:

insert into USER_PENDING (UP_USER_NO, UP_TIME_STAMP, UP_EMAIL_ADDRESS, UP_LAST_NAME, UP_FIRST_NAME, UP_SCMB_CLIENT) values (USER_PENDING_SEQ.nextval,TO_DATE('21/12/1997 15:05:11','DD/MM/YYYY, HH24:MI:SS'),'jarred_at_vwv.com', 'gfg','fgsdfgs','O') Statement executed.

This works 100%.

I add one more column to the insert, called UP_IDENTITY_NO, a varchar2(15), and get the following result:

insert into USER_PENDING (UP_USER_NO, UP_TIME_STAMP, UP_EMAIL_ADDRESS, UP_LAST_NAME, UP_FIRST_NAME, UP_SCMB_CLIENT, UP_IDENTITY_NO) values (USER_PENDING_SEQ.nextval,TO_DATE('21/12/1997 15:05:11','DD/MM/YYYY, HH24:MI:SS'),'jarred_at_vwv.com', 'gfg','fgsdfgs','O','id number')
[OpenLink][ODBC][Oracle Server]ORA-01756: quoted string not properly
terminated, SQLSTATE=S1000
[OpenLink][ODBC][Driver]Syntax error or access, SQLSTATE=37000

Umm - when last I looked, 'id number' was a properly terminated quoted string. Anyway, it gets better. I substitute a different column, this time called UP_ACCOUNT_NO, a varchar2(50).

insert into USER_PENDING (UP_USER_NO, UP_TIME_STAMP, UP_EMAIL_ADDRESS, UP_LAST_NAME, UP_FIRST_NAME, UP_SCMB_CLIENT, UP_ACCOUNT_NO) values (USER_PENDING_SEQ.nextval,TO_DATE('21/12/1997 15:05:11','DD/MM/YYYY, HH24:MI:SS'),'jarred_at_vwv.com', 'gfg','fgsdfgs','O','id number')
[OpenLink][ODBC][Oracle Server]ORA-00900: invalid SQL statement,
SQLSTATE=S1000
[OpenLink][ODBC][Driver]Syntax error or access, SQLSTATE=37000

Now as can be seen, the SQL statement is invalid.

Anyone shed any ideas as to why?

System is an Oracle 7-3-3 server running under NT v4.0. Client is a Solaris 2-5-1 machine running Openlink ODBC driver suite.

Regards,
Graham

-- 
-----------------------------------------
graham_at_vwv.com			"There's a moon
VWV Interactive				over Bourbon Street
						tonight...