Ref cursor in stored proc out param

[pamposh]

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.