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.
