You can probably add a step in your KM, choose Oracle as the technology and run the code :
BEGIN DBMS_APPLICATION_INFO.SET_MODULE(<%=odiRef.getInfo("TARG_NAME")>','') END;
I don't see why it wouldn't work.
I thought this.if ı add it as new step IKM that first step.Now during the IKM processing Will it return to me my "TARG_NAME"as session name when I look session browser of Toad?.
Or ı will see my TARG_NAME as session name when JUST new step is executioning that ı added ?Not during the IKM proccess
I've never used DBMS_APPLICATION_INFO but from what I understand in the doc, it should work for the whole IKM execution.
Best thing to do is to try .
Thanks Your reply.
Right.That link was helpful for me .It worked.But Now we are using ODI 10g .There is no on Connect/Disconnect tab :/
But I used in insert step of IKM or LKM like this:
DBMS_APPLICATION_INFO.set_module (module_name',' ');
(Original IKM or LKM insert code)
then it works
Another question.Could you say me how I will mark as answered
Glad it worked .
I don't think you can mark it as answered because you didn't thick the "Mark this discussion as a question" checkbox when you created the thread. You can maybe select this option if you edit the first message.