went the other way... created the oracle procedure... cant figure out the syntax to call it from SQL?

Thanks for the info and sorry bout the wrong forum... I dont know oracle well enough to do it from that side... I'll do some reading on the tally table.....

Yeah, that would be the ideal solution, but as this is a QA server for a production system, I can't just install SP2... it will be weeks of paperwork.... ...