PL/SQL problem with Ingres db link
585732Jun 29 2007 — edited Jun 29 2007Hi,
I have a problem with INSERT to Ingres through database link.
In PL/SQL, if I write:
UPDATE unit@ERP SET "wcs_ack" = '06-29-2007 03:06:57' WHERE "unitidnr" = 100003;
Then there's no problem. But when I use PL/SQL variablese like:
pl_unitidnr := 100003;
pl_current_timestamp := '06-29-2007 03:06:57';
UPDATE unit@ERP SET "wcs_ack" = pl_current_timestamp WHERE "unitidnr" = pl_unitidnr;
Then I get message:
CALL PKG_UNIT.PRD_COPY_UNITS_FROM_ERP()
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Ingres][Ingres 3.0 ODBC Driver]SQL data type out of range (SQL State: S1004; SQL Code: 0)
It doesn't seem to make a difference which datatype I use for pl_ variables, have tried NUMBER, INTEGER etc.. None of them work. Can anyone help me?
Sincerely,
Jukka