Kbase P40357: ODBC connection from Oracle using SQL curdate function fails
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2003 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
ODBC connection from Oracle to Progress database on Sun SPARC
Using Oracle's SQL*PLUS for ODBC connection to Progress database
Receiving Oracle error: 0ra=-00904 Invalid Identifier
Using curdate outside of Oracle accesses Progress database without error.
CHANGE:
Incorporating SQL curdate function into query
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
Restructure the query using sysdate in place of curdate:
jar_pickup_schedule_id varchar2(100);
jar_pickup_schedule_id := 'Update pub."audit"@bstar set "processeddt" = ' || '''' || sysdate || '''';