Posted on 2004-03-23
i have few question about DTS :
- how to pass global variable to PL/SQL procedure (when i put "?" as one of arguments - it says -" sql statement does not contain any parameters"
- how to implement "if/case -logic"
i want to analyze the value of global variable and depending on this value execute one or another step ....
- i am executing 10 transformation concurrently and sending success email if all of them succeed, now i need to send a failure email if at least one of these 10 transformations fails. how to do this ?
thanks in advance,