hi all
i have cdc stage in my job and after job will be invoked i need to call some sql statement in database ( oracle ) and pass/get data from
1 cdc -> 2 call db -> 3 process some logic -> 4 call target
i'm interested in 2 step
how to implement 2 step for calling database
is it routine ? with oci call ?
thanks
call database after cdc stage
Moderators: chulett, rschirm, roy
Well... just repeating everything doesn't help all that much but if "2 step" means you need help with Step #2 you'll need two jobs for that AFAIK. Unless something has changed in the architecture since last I used the product, a connector can be either a source OR a target but not both. So, 1 and 2 would need to be one job and then 2 again to "return some data" along with 3 and 4 in another job.
If that's not feasible in your case, we'd need specifics as to the "why not" of it in order to help, I would imagine.
If that's not feasible in your case, we'd need specifics as to the "why not" of it in order to help, I would imagine.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: