camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pamposh <arunkauldaft...@gmail.com>
Subject Ref cursor in stored proc out param
Date Wed, 03 May 2017 15:13:21 GMT
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.

Mime
View raw message