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

phanibabuk over 9 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

0 phanibabuk over 9 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
0 phanibabuk over 9 years ago

...ession.CustomFunction.eval0(CustomFunction.java:188)
at com.appiancorp.core.expr.Evaluable.eval(Evaluable.java:213)

Any inputs are appreciated!!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 phanibabuk over 9 years ago

Any inputs please...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

Check this plug-in to execute store procedures, maybe you can use it as-is or use it as an example forum.appian.com/.../summary
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 andrewb389 over 9 years ago

@phanibabuk did you solve this issue? As I've got a problem very similar to this
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

Some more ideas at forum.appian.com/.../f-142981
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel