- Joined
- Jul 20, 2002
I've written stored procedures for both SQL server 2000 and MySQL and never had to use
a cursor to return a result set (i.e. more than one row of data). In Oracle 10g you have to
use a cursor. I also had to define a whole f'ing package with a defined record
for the cursor just to create a dead simple stored procedure. In Oracle 10g to return a
single row of data from a stored procedure you have to use local variables and the INTO clause.
Does the reason for all these extra procedural steps have something to do w/enhancing
security?
a cursor to return a result set (i.e. more than one row of data). In Oracle 10g you have to
use a cursor. I also had to define a whole f'ing package with a defined record
for the cursor just to create a dead simple stored procedure. In Oracle 10g to return a
single row of data from a stored procedure you have to use local variables and the INTO clause.
Does the reason for all these extra procedural steps have something to do w/enhancing
security?