Skip to Main Content

Oracle Content Management

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI variables in a Package not substituting values into topology.

Aman KumarDec 12 2024

Hi All,

I have below requirement where I have created a topology using wallet feature where I entered just the jdbc like jdbc:thin:host@#project.v_username

And #project.v_username is refresh variable which will take the username from a database table username_details.

I have an interface which is loading data from a table to a table and my source table is present in multiple schema and I have to implement a loop which in each loop fetch the username from a table one by one and substitute v_username in topology and fetch data from that schema.

I have created my package like

#project.v-counter-to get the count of schema in the table username_details.

Evaluate V_counter greater than 0

V_username-which is getting username one by one like

Select username,row_num() over order by user and desc as counter from username_details where counter=#project.v_counter

Interface

Set variable v_counter increment by -1.

Now when I execute this package I can see variables getting substituted correctly in operator but in actual data getting loaded from only the first username in the table even though the variable v_username is getting substituted correctly.

Please let me know what can be the issue in this.

Comments
Post Details
Added on Dec 12 2024
0 comments
137 views