The database is running user defined data type, so the selct you are running is attempting to convert the SECCODEID(varchar) to an INT, data type.

If you did

SELECT * from PDW_SLX.sysdba.SECCODE where SECCODEID='1'

This will run without a problem.