Hey,
I have a stored procedure that updates one colun in Table A based on some condition in Table B.
I created one stored procedure in Oracle 9i. This SP doesnt return any info. It only updates Table A.
I created one Server job C in Datastage using OraOci9. After running the job, I have to run the stored procedure. I dont want to run SP manually.
Can any one help me how to run this SP.
thanks a lot in advance?
Lak
I have a stored procedure that updates one colun in Table A based on some condition in Table B.
I created one stored procedure in Oracle 9i. This SP doesnt return any info. It only updates Table A.
I created one Server job C in Datastage using OraOci9. After running the job, I have to run the stored procedure. I dont want to run SP manually.
Can any one help me how to run this SP.
thanks a lot in advance?
Lak