Posted: Wed Jan 23, 2008 3:50 pm
You CAN collect statistics, brew a cup of coffee, whatever, between two processes.
What you can't do is expect the SP stage to "pass" rows thru like it's not even there. The SP stage will "do something" for you and give you back an answer, it will not pass rows thru it. Do you understand why I originally posted about a "square peg in a round hole"? You're trying to do something that doesn't work the way you want it to.
Please understand that your job design is the issue, not the functionality of the stages. If you understand what/how the stages operate, you would understand that the mechanism you want to use requires you to design your job differently. I've given you the design that works according to the stages you have stated you must use.
The SP stage is used to "run something" and tell you how it worked. If you want to use an SP to get data, then you use the OCI stage and select stored procedure as the SQL method. You're trying to get rows being input into the SP stage to come out the output link, WHICH DOESN'T WORK.
What you can't do is expect the SP stage to "pass" rows thru like it's not even there. The SP stage will "do something" for you and give you back an answer, it will not pass rows thru it. Do you understand why I originally posted about a "square peg in a round hole"? You're trying to do something that doesn't work the way you want it to.
Please understand that your job design is the issue, not the functionality of the stages. If you understand what/how the stages operate, you would understand that the mechanism you want to use requires you to design your job differently. I've given you the design that works according to the stages you have stated you must use.
The SP stage is used to "run something" and tell you how it worked. If you want to use an SP to get data, then you use the OCI stage and select stored procedure as the SQL method. You're trying to get rows being input into the SP stage to come out the output link, WHICH DOESN'T WORK.