In MSSQL Server you could use a Select statement in a stored procedure to return many rows of data. In Oracle, it seems that you need PL/SQL to open a cursor, return the rows in a cursor and then print the cursor using SQL/Plus or a similar tool. I need to use an ODBC connection to run a stored procedure to return many rows of data via a stored procedure. This was simple in SQL Server - so how do I do this in Oracle. It seems that I am missing something, as this should be very straighforward. My front end is written to talk to SQL Server stored procedures to return data, and I want to do a minimal amount of changes to get this front end to talk to Oracle. Many of the selects are too complex to run directly as select statements without procedures.