[Stackoverflow] [Progress OpenEdge ABL] How to avoid Invalid number string error in OpenEdge DB?

Status
Not open for further replies.
P

Paul Stearns

Guest
I am accessing an 11.7 OE Enterprise RDBMS. I have two simple queries, one which works another which doesn't. In the queries below the LAB_VALUE field is a varchar data type. The first query returns 106 rows with no issues. The second query dies immediately.

Query 1;

Code:
SELECT to_number(LAB_VALUE) LAB_VALUE 
FROM labrec_view
WHERE lab_yr_mon = 202006 AND 
      FACILITY_CODE = 'BUF' AND 
      LAB_RESULT_CODE = 'ALBUMIN'

Query2;

Code:
SELECT to_number(LAB_VALUE) LAB_VALUE 
FROM labrec_view
WHERE lab_yr_mon = 202006 AND 
      FACILITY_CODE = 'BUF' AND 
      LAB_RESULT_CODE = 'ALBUMIN' and
      to_number(LAB_VALUE) > 4

The error received is;

Code:
SQLState=HY000
ErrorCode=-20232
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Invalid number string (7498)

I am at a loss. There is an KB atricle;

Progress KB - Invalid number string (7498) returned by SQL query on OE 10.2B

But it seems to refer to older versions of OpenEdge and specifically states 11.7 should correct the issue.

I am not a Progress DB person, and I only have access to query views in the DB as a specific R/O user.

Where do I go from here in troubleshooting?

Continue reading...
 
Status
Not open for further replies.
Top