Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Stored procedure running from Datastage

Status
Not open for further replies.

lsrinivas

Technical User
Jan 14, 2005
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top