This SQL query ran ok in EA v13 but errors with 'OraOLEDB [-2147467259] ORA-01722: invalid number'
in EA v 13.5:
Select
--Look for an association class and list the source and target class of the association
-- The 'AS' clause needs to be followed by a simple string or eaDocX searches don't work
ifO.ea_guid AS CLASSGUID,
ifO.Object_Type As CLASSTYPE,
ifO.Alias As IF_ID,
-- Replace any commas in the interface name result so we don't confuse CSV!
Replace(ifO.Name, ',',';') AS IF_NAME,
ifO.Status As IF_STATUS,
ifO.PDATA5 As CAPABILITY,
srcO.Name AS SRC_SYS_NAME,
tgtO.Name AS TGT_SYS_NAME
FROM t_object tgtO , t_object srcO, t_connector, t_object ifO, t_package pkg
WHERE
-- These macros dont work in eaDocX searches - no results will be output
pkg.Package_ID in (#Branch#) AND ifO.Package_ID = pkg.Package_ID
AND tgtO.Object_ID = t_connector.End_Object_ID
AND srcO.Object_ID = t_connector.Start_Object_ID
AND t_connector.PDATA1 IS NOT NULL
AND ifO.Object_ID = To_Number(t_connector.PDATA1)
AND ifO.Stereotype like '%interface%'
ORDER by 1
Whoops it doesn't work in EA v 13 either, but it used too! Other scripts also work so not an OLDEB problem.