That's not right. Oracle does not return any thing from a procedure unless it is passed by reference. It is therefore impossible for a cursor to be returned from a stored procedure. SQL pass through of a select statement doesn’t call a stored proc so it will return a cursor.