Hi Arun, do you have `camel-sql-x.y.z.jar` on your classpath? See the documentation[1] on how to add it if you're using Maven,
zoran [1] https://camel.apache.org/sql-stored-procedure.html On Tue, May 2, 2017 at 10:14 PM, pamposh <[email protected]> wrote: > I am calling following oracle stored procedure as via camel but getting this > error below.what is the issue here? > > endpoint uri: > this.endpointUri = new URI("sql-stored", TEST_SQL , "dataSource=" + > DBConstants.DATA_SOURCE_NAME).toASCIIString(); > > template: > public static final String TEST_SQL = "MyAdd(number ${headers.num1},number > ${headers.num2},OUT number resultofsub)"; > > proc: > create or replace procedure MyAdd (first in number,second in number,outparam > OUT VARCHAR2) AS > begin > select first+second into outparam from dual; > end; > > SQL BEING PROCESSED MyAdd(number ${headers.num1},number ${headers.num2},OUT > number resultofsub) > > [ERROR] [05/02/2017 15:57:13.278] > [systemManagerActor-akka.actor.default-dispatcher-3] > [akka://systemManagerActor/user/camel-supervisor/registry/producerRegistrar] > Actor[akka://systemManagerActor/user/dispatchSummaryEventProcessorActor/$b#1331778070] > failed to activate > **org.apache.camel.ResolveEndpointFailedException: Failed to resolve > endpoint: > sql-stored://MyAdd(number%20$%7Bheaders.num1%7D,number%20$%7Bheaders.num2%7D,OUT%20number%20resultofsub)?dataSource=localOracle > due to: No component found with scheme: sql-stored > at > org.apache.camel.impl.DefaultCamelContext.getEndpoint(DefaultCamelContext.java:543) > at > akka.camel.internal.ProducerRegistrar$$anonfun$receive$3.applyOrElse*(*CamelSupervisor.scala:164) > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-oracle-db-integration-tp5798581.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Zoran Regvart
