Nasty You need to set up a linked server from SQL to Oracle, this will give you access to the table. This is a particularly nasty thing to have to do, the server name will then be hard coded into your procedure and will require modification when you promote the proc from dev/uat to production. (and I hate linked servers and I hate setting up Oracle and....) Good Luck.
Never underestimate the power of human stupidity RAH