Hi All,
I am getting this error while updating a Oracle 8.1 table
Terminate.terminate,0: Open failed for update. Update is: UPDATE
schemaName.EMPLOYEE
SET
END_DT = :END_DT, POST_DTS = :POST_DTS
WHERE
(EMPLOYEE_NBR = :EMPLOYEE_NBR)
sqlcode is: -1475
esql complaint: ORA-01475: must reparse cursor to change bind variable datatype
I checked the datatypes and they are ok...
Any ideas in which direction i have to proceed...
Thanks in advance
Jay
Update error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What Sainath is saying is that you require a statement of the form for Oracle, or for ODBC and most other databases.
Code: Select all
UPDATE
schemaName.EMPLOYEE
SET
END_DT = :2, POST_DTS = :3
WHERE
(EMPLOYEE_NBR = :1)
Code: Select all
UPDATE
schemaName.EMPLOYEE
SET
END_DT = ?, POST_DTS = ?
WHERE
(EMPLOYEE_NBR = ?)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.