Hi Rajib,
what you're seeing as `{result=Hello World OUT parameter}` is the
String representation of a Java Map, you can reference values in the
map using their keys, i.e. Camel Simple language expression
`${body[result]}` should give you the content you need.Take a look at the documentation on the Simple language: https://github.com/apache/camel/blob/master/core/camel-base/src/main/docs/simple-language.adoc zoran On Tue, Jun 11, 2019 at 6:00 AM Rajib Deb <[email protected]> wrote: > > Hi > I am writing a camel route to call a stored procedure and get the return > value. I am able to get it but it is coming as below > > rajib after creatcredit {result=Hello World OUT parameter} > > However, I need only " Hello World OUT parameter" in the body and not result= > concatenated with the output. Please let me know how to achieve that. > > This is my camel route > ---------------------------------- > from("kafka:localhost:xxxxx?topic=xxxxxx&groupId=xxxx&autoOffsetReset=earliest&consumersCount=1").routeId("xxxx") > .to("sql-stored:procOneOUTParameter(OUT VARCHAR result)") > .log("rajib after creatcredit ${body}"); > > > This is the stored procedure > ----------------------------------------- > CREATE OR REPLACE PROCEDURE procOneOUTParameter(outParam1 OUT VARCHAR2) > IS > BEGIN > > outParam1 := 'Hello World OUT parameter'; > > END; > / > > Thanks > Rajib -- Zoran Regvart
