Skip to Content
0
Former Member
May 05, 2009 at 12:41 PM

SAP PI 7.1 Workaround for JDBC LookUp wizard

21 Views

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