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