| ORA-01722 [message #374148] |
Mon, 28 May 2001 08:56 |
Stephen
Messages: 26
Registered: January 2000
|
Junior Member |
|
|
A strange problem...
We run Fortran-programs on an Alpha-server connected to an Oracle DB (Oracle8).
I want to execute a query in the program (Embedded SQL) but I always get the error: ORA-01722
In the query I've put the CONCAT-function in the WHERE-clause. Trying this query in sql*plus and pl/sql didn't give any errors, so I think it should be executable. Maybe there is something wrong with the precompiler that generates Fortran or isn't it possible to use such a function in Embedded SQL?
The query is:
SELECT Field1, Field2
INTO :F1, :F2
FROM Table1
WHERE CONCAT(Field1,Field2) >= '3B01'
AND CONCAT(Field1,Field2) <= '3E05';
All the fields are alphanumeric
Anybody a solution?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
