I am trying out a stored procedure which takes only one parameter as an input wh

anagha_abhyankar over 10 years ago

I am trying out a stored procedure which takes only one parameter as an input which is a ref cursor. I am passing a CDT which has same datatypes as in the elements in ref_cursor. However, when I try to run the proc with correct datasource name and proc name, it fails. I am getting below logs:

2014-07-15 20:25:34,258 [default-threads - 21] DEBUG com.appiancorp.ps.ss.ExecuteStoredProcedure - [268538490] RTECH.AP_SAVECURSOR has column AP_INCURSOR with data type 1111 (REF CURSOR) and column type 1
2014-07-15 20:25:34,259 [default-threads - 21] DEBUG com.appiancorp.ps.ss.ExecuteStoredProcedure - [268538490] RTECH.AP_SAVECURSOR setting input AP_INCURSOR to [[Ljava.lang.Object;@56604081
2014-07-15 20:25:34,259 [default-threads - 21] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268787903, classname=com.appiancorp.ps.ss.ExecuteStoredProcedure
com.appiancorp.suiteapi.process.exceptions.Sm...

Discussion posts and replies are publicly visible

Parents

0 anagha_abhyankar over 10 years ago

...artServiceException: java.sql.SQLException: Invalid column type

Any clues?

Thanks,

Anagha
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 anagha_abhyankar over 10 years ago

...artServiceException: java.sql.SQLException: Invalid column type

Any clues?

Thanks,

Anagha
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data