Re: SOLVED: Problem calling an Oracle stored procedure from SQR

[Christopher Wanko <WankoC@WYETH.COM>]

>>>
MANY thanks to Peter Alan Burton of BRIO, who provided the following
solution. This did the trick nicely!
>>>

If you're already using a stored proc to help generate workorders, why not 
write the entire workorder gen in a stored proc?  It'll be much faster than an 
SQR program over ODBC (or even native Oracle connectivity) and you have the 
power of PL/SQL at your disposal.  You could then just kick off the stored proc 
with an SQR program if necessary.

-Chris