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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI variables in a Package not substituting values into topology.

3154987Dec 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

SiatGesi Feb 14 2025

THE FIRST problem howto wrap I have resolved…

SiatGesi Feb 14 2025

now I'm trying to move the unzipped files (pictures) from db to AS… my real problem… best regards

1 - 2

Post Details

Added on Dec 12 2024
0 comments
53 views