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?