Hi
I dont think cursor is supported in the Camel component as outputs.
On Wed, May 3, 2017 at 11:13 AM, pamposh <arunkauldaft...@gmail.com> wrote:
> Hi,
>
> I am calling oracle stored procedure with ref_cursor OUT parameter, using
> camel sql-stored but getting following error.How to use ref cursor with
> camel?
>
> *SQL:*
> public static final String TEST_SQL = "getEvtSummary(OUT ref_cursor
> res,INTEGER ${headers.p_evt_id},INTEGER ${headers.p_status_id})";
>
> *PROC*
> PROCEDURE getEventSummary (aref_out OUT ref_cursor,
> p_evt_id IN NUMBER DEFAULT NULL,
> p_status_id IN NUMBER DEFAULT NULL)
> AS
> BEGIN
> OPEN aref_out FOR
> SELECT evt_id,
> source_id,
> description,
> comments,
> status_id
> FROM IDP_T_EVT_SUMMARY
> WHERE IDP_T_EVT_SUMMARY.status_id = 1;
> END getEventSummary;
>
> *Error*
> akka.camel.AkkaCamelException: Field ref_cursor not found from
> java.procedureName.Types
> at
> akka.camel.ProducerSupport$$anonfun$produce$1.applyOrElse(Producer.scala:73)
> at
> scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:36)
> at
> akka.camel.javaapi.UntypedProducerActor.onReceive(UntypedProducerActor.scala:49)
> at
> akka.actor.UntypedActor$$anonfun$receive$1.applyOrElse(UntypedActor.scala:165)
> at akka.actor.Actor$class.aroundReceive(Actor.scala:497)
> at akka.actor.UntypedActor.aroundReceive(UntypedActor.scala:95)
> at akka.actor.ActorCell.receiveMessage(ActorCell.scala:526)
> at akka.actor.ActorCell.invoke(ActorCell.scala:495)
> at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:257)
> at akka.dispatch.Mailbox.run(Mailbox.scala:224)
> at akka.dispatch.Mailbox.exec(Mailbox.scala:234)
> at
> scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
> at
> scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
> at
> scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
> at
> scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
> *Caused by:
> org.apache.camel.component.sql.stored.template.ast.ParseRuntimeException:
> Field ref_cursor not found from java.procedureName.Types
> *
>
>
> Regards
> Arun
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Ref-cursor-in-stored-proc-out-param-tp5798615.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2
