SQLConnection1.GetProcedureNames(ListBox1.Items);竟然会出现下面的错误 'ora-00936:遗漏表达式' 用SQLMonitor1来观察得到的语句是: SELECT 0, '', A.OWNER, A.OBJECT_NAME, 0, COUNT(*), 0, A.PACKAGE_NAME FROM SYS.ALL_ARGUMENTS A, SYS.ALL_OBJECTS O WHERE O.OBJECT_ID = A.OBJECT_ID AND O.STATUS <> 'INVALID' AND A.OWNER LIKE 'SFIS1' AND (A.PACKAGE_NAME IS NULL OR A.PACKAGE_NAME = A.OBJECT_NAME) AND ( O.OBJECT_TYPE = 'PROCEDURE' OR ) GROUP BY A.OWNER, A.PACKAGE_NAME, A.OBJECT_NAME ORDER BY A.OWNER, A.PACKAGE_NAME, A.OBJECT_NAME 这句( O.OBJECT_TYPE = 'PROCEDURE' OR )很明显有问题啊!还有,若SQLQuery1查询的结果为空,则SQLQuery1.RecordCount就会报错???????????????????????????????????
oracle对ADO支持的不够好!DBEXPRESS,使用数据库的原生驱动
而且我怀疑DBEXPREESS的前途!!!
sorry 请问odac 是什么?
'ora-00936:遗漏表达式'
用SQLMonitor1来观察得到的语句是:
SELECT 0, '', A.OWNER, A.OBJECT_NAME, 0, COUNT(*), 0, A.PACKAGE_NAME FROM SYS.ALL_ARGUMENTS A, SYS.ALL_OBJECTS O WHERE O.OBJECT_ID = A.OBJECT_ID AND O.STATUS <> 'INVALID' AND A.OWNER LIKE 'SFIS1' AND (A.PACKAGE_NAME IS NULL OR A.PACKAGE_NAME = A.OBJECT_NAME) AND ( O.OBJECT_TYPE = 'PROCEDURE' OR ) GROUP BY A.OWNER, A.PACKAGE_NAME, A.OBJECT_NAME ORDER BY A.OWNER, A.PACKAGE_NAME, A.OBJECT_NAME
这句( O.OBJECT_TYPE = 'PROCEDURE' OR )很明显有问题啊!还有,若SQLQuery1查询的结果为空,则SQLQuery1.RecordCount就会报错???????????????????????????????????