ORA-00900: invalid SQL statement
Moderators: chulett, rschirm, roy
ORA-00900: invalid SQL statement
Hi,
I am updating records in DRS Stage with the following update statment.(generated statment)
UPDATE tablename
SET EFF_STATUS=?,
DESCR=?,
DESCRSHORT=?,
GVT_VET_RECR_CODE=?,
GVT_VET_RECR_PTS=?,
HRS_ROW_ADD_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
HRS_ROW_ADD_OPRID=?,
HRS_ROW_UPD_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
HRS_ROW_UPD_OPRID=?,
LOAD_ERROR=?,
DATA_ORIGIN=?,
CREATED_EW_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
LASTUPD_EW_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
BATCH_SID=?
WHERE GVT_VET_PREF_APPT=? AND EFFDT=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS') AND SRC_SYS_ID=?;
After updating records it is throwing this warning message
ORA-00900: invalid SQL statement
I am not able to pin point the problem in the sql statment.Can you please help me out
Thanks
Sri
I am updating records in DRS Stage with the following update statment.(generated statment)
UPDATE tablename
SET EFF_STATUS=?,
DESCR=?,
DESCRSHORT=?,
GVT_VET_RECR_CODE=?,
GVT_VET_RECR_PTS=?,
HRS_ROW_ADD_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
HRS_ROW_ADD_OPRID=?,
HRS_ROW_UPD_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
HRS_ROW_UPD_OPRID=?,
LOAD_ERROR=?,
DATA_ORIGIN=?,
CREATED_EW_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
LASTUPD_EW_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'),
BATCH_SID=?
WHERE GVT_VET_PREF_APPT=? AND EFFDT=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS') AND SRC_SYS_ID=?;
After updating records it is throwing this warning message
ORA-00900: invalid SQL statement
I am not able to pin point the problem in the sql statment.Can you please help me out
Thanks
Sri
So the job runs and records are updated in the database but then it throws a warning at the end?
Have you tried running it with just one record which you know performs an update? Does the warning still occur? It may be data related, otherwise not sure why it would work for some records and then throw warning.
Have you tried running it with just one record which you know performs an update? Does the warning still occur? It may be data related, otherwise not sure why it would work for some records and then throw warning.
Regards,
Nick.
Nick.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: ORA-00900: invalid SQL statement
Also check if there is an output link from this stage to any other stage such as a Hashed File and if the select statement in that one is ok...
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
From Oracle Error message list i got this, I don't know but it might help you.
Code: Select all
ORA-00900 invalid SQL statement
Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.
Action: Correct the syntax or install the Procedural Option.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: