Oracle SQL - Call a stored procedure with a cursor out parameter
Posted on 2007-10-05
I have a stored procedure I'm using to return a recordset with a cursor as an out parameter to return a recordset. I'm seeing some strange data when I bring the data into Crystal Reports. In the SQL server world, I'd just go directly to Management Studio, open a 'new query' and execute the procedure... but in SQL server I don't need to use a cursor to return a recordset, I just 'DO' the select. How see the results in 'Oracle SQL Developer' the same way I would in sql server management studio (or the old 'query analyzer') ???