SAP PI 7.1 Workaround for JDBC LookUp wizard

[Former Member]

Hi everybody,

unfortunately we cannot use the wizard, because we want a to get a PL/SQL sequence; e.g.

"select MYTABLE.NEXTVAL from DUAL";

so I have to use my "old" UDF with a JDBC lookUp.

But there is one thing I would like to improve. As it is possible to set a communication channel as a parameter in graphical message mapping, I'd like to get the value of the CC in my UDF.

Is this possible?

a) give CC as JDBC-parameter

b) get the Value of the JDBC-parameter of the parameter in the UDF?

Thanks

regards Mario

[Former Member]

solved it.

it is not possible to use JDBC-Parameter, but U can use simple parameters.

Regards Mario