We are working on an oracle port project where in the application is being moved from sql server database to oracle, without effecting the front end code a bit...which means..I need to do in oracle what happens in sqlserver ...DITTO.
Now I have 1 scenario which I am not sure how to go about with.
SQLSERVER has this funda of of returing recordsets to front end just by using a select statement.eg...
this would return a recordset to front end..
create proc test
select empname,empno from emp
In oracle I need to use ref cursor's for this...
But there are some places where in I have something like this in sqlserver
Now I am not really sure how many select's are going to be in cursor before hand...so the count of ref-cursor's is unknown.
CREATE PROC totalshyt
DECLARE c1 CURSOR FOR
SELECT empno,empname FROM emp
OPEN AND FETCH THE CURSOR
SELECT empsomething FROM address WHERE firstname.lastname@example.org
Can anyone please let me know how to go about with this?