Hi all, We tried creating a custom plug-in in Appian which does an operatio

phanibabuk over 10 years ago

Hi all,
We tried creating a custom plug-in in Appian which does an operation on a database package.

Our goal is to invoke the procedure within an Oracle package using the custom plug-in.

We are able to invoke the procedure directly. However, we are not able to invoke the procedure within an Oracle package.

We are getting the below error:

2015-01-06 14:42:13,293 [[ACTIVE] ExecuteThread: '26' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.appiancorp.plugins.processreport.ProcessListHelper - error while inserting process data
java.lang.ClassCastException: weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection cannot be cast to oracle.jdbc.OracleConnection
at oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:159)
at oracle.sql.StructDescriptor.createDescriptor(StructDescriptor.java:130)
at com.appiancorp.plugins.processreport.ProcessListHelper.insertUpdateProcessData(ProcessListHelper....

PACKAGE-INFO.txt

Discussion posts and replies are publicly visible

Parents

0 phanibabuk over 10 years ago

...java:156)
at com.appiancorp.plugins.processreport.ProcessListHelper.getProcessList(ProcessListHelper.java:65)
at com.appiancorp.plugins.processreport.ProcessReportGenerator.processlist(ProcessReportGenerator.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.appiancorp.process.expression.CustomFunction$1.call(CustomFunction.java:735)
at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
at com.appiancorp.process.expression.CustomFunction.evaluate(CustomFunction.java:730)
at com.appiancorp.process.expression.CustomFunction.evalDynamic(CustomFunction.java:197)
at com.appiancorp.process.expr...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 phanibabuk over 10 years ago

...java:156)
at com.appiancorp.plugins.processreport.ProcessListHelper.getProcessList(ProcessListHelper.java:65)
at com.appiancorp.plugins.processreport.ProcessReportGenerator.processlist(ProcessReportGenerator.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.appiancorp.process.expression.CustomFunction$1.call(CustomFunction.java:735)
at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
at com.appiancorp.process.expression.CustomFunction.evaluate(CustomFunction.java:730)
at com.appiancorp.process.expression.CustomFunction.evalDynamic(CustomFunction.java:197)
at com.appiancorp.process.expr...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data