Stored Procedures and Result Sets

From: Ron Matyjanka <ron.matyjanka_at_nospamshaw.wave.ca>
Date: Tue, 18 Aug 1998 17:57:04 GMT
Message-ID: <QfjC1.5361$hr3.2642066_at_news.rdc1.bc.wave.home.com>

I'm porting an application that uses to ODBC and SQL Server 6.5 to Oracle 8, and I've encountered some differences in the way stored procedures are dealt with.

It appears that stored procedures in Oracle 8 cannot return a result set, and that you are limited to OUT parameters declared in the stored procedure. Is this true, or is there some way to return multiple rows of data from a stored procedure?

One more question: how do the OUT parameters look to ODBC?

Thanks,

Ron Matyjanka Received on Tue Aug 18 1998 - 19:57:04 CEST