AnsweredAssumed Answered

GEL error using % character

Question asked by Lowell on Sep 11, 2009
Latest reply on Sep 12, 2009 by federico
I get the following error message when attempting  to run a GEL SQL query in Oracle.   How do I get around  GEL not being able to handle the Oracle Variable operator (%)?    and Res.Full_OBS like '%/A-RITS TRG CIO%': [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00920: invalid relational operator      at org.apache.commons.jelly.tags.sql.QueryTag.doTag(QueryTag.java:194)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:247)
at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:95)
at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:186)
at com.niku.union.gel.tags.ScriptTag.doTag(ScriptTag.java:20)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:247)
at com.niku.union.gel.GELScript.run(GELScript.java:80)
at com.niku.union.gel.GELController.invoke(GELController.java:20)
at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00920: invalid relational operator

at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ca.clarity.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.ca.clarity.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.ca.clarity.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$78784047.executeQuery( )
at org.apache.commons.jelly.tags.sql.QueryTag.doTag(QueryTag.java:175)
....

Outcomes