You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by pamposh <ar...@gmail.com> on 2017/05/03 15:13:21 UTC
Ref cursor in stored proc out param
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.
Re: Ref cursor in stored proc out param
Posted by Claus Ibsen <cl...@gmail.com>.
Hi
I dont think cursor is supported in the Camel component as outputs.
On Wed, May 3, 2017 at 11:13 AM, pamposh <ar...@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