db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Sean Taylor <da...@bluesunrise.com>
Subject readModelFromDatabase failure Oracle ORA-01424: missing or illegal character following the escape
Date Wed, 03 Jan 2007 01:28:24 GMT
I am experiencing a problem running with oracle(10)
When calling platform.readModelFromDatabase(databaseName);
I get the error described here:

http://mail-archives.apache.org/mod_mbox/db-ddlutils-dev/200512.mbox/%3C200512080904.AFX76995@persistent.co.in%3E

Exception in thread "main" org.apache.ddlutils.DynaSqlException:
java.sql.SQLExc
eption: ORA-01424: missing or illegal character following the escape
character
     at
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(Platform
ImplBase.java:1075)

Took the advise in the response to that question, installed P6SPY and 
here is snippet of what the spy is logging, there are lots more of these 
selects from user_triggers. Seems like the select from RECYCLEBIN.

Could someone tell me exactly is going on here with all these select 
statements from user_triggers and RECYCLEBIN, and why is the last select 
failing


1167783281219|0|1|statement|SELECT * FROM user_triggers WHERE 
trigger_name = ?|SELECT * FROM user_triggers WHERE trigger_name = 
'trg_WWV_FLOW_FI_CTS$_FILE_TYPE'
1167783281229|0|1|statement|SELECT * FROM user_triggers WHERE 
trigger_name = ?|SELECT * FROM user_triggers WHERE trigger_name = 
'trg_WWV_FLOW_FI_$_FILE_CHARSET'
1167783281239|10|1|statement|SELECT * FROM RECYCLEBIN WHERE 
OBJECT_NAME=?|SELECT * FROM RECYCLEBIN WHERE 
OBJECT_NAME='BIN$+TErOhpGR5mp9OdJ/LDNFw==$0'

Mime
View raw message