Using EA13 and eaDocX 3.9 on Windows 7 Pro.
I get this SQL Oracle error when using third party app eaDocX (eaDocX lets you create a table based on an SQL search in version 3.9) (It works fine as an EA search). Ive tried it on tiny results (two rows and hundreds of rows) - same error. Tried everything I can think of!
28/04/2017 13:49:29
Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
[Oracle][ODBC][Ora]ORA-00911: invalid character
Context:
Select
ifO.ea_guid AS CLASSGUID,
ifO.Object_Type AS CLASSTYPE,
ifO.Alias AS IFID,
Replace(ifO.Name, ',',';') AS IFNAME,
ifO.Status AS IFSTATUS,
ifO.PDATA5 AS CAPABILITY,
srcO.Name AS SRCSYSNAME,
tgtO.Name AS TGTSYSNAME
FROM t_object tgtO , t_object srcO, t_connector, t_object ifO, t_package pkg
WHERE
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='interface'
ORDER by 1
