Can we specify return type for Static cursors? If yes Can any one give example?
Can we specify return type for Static cursors? If yes Can any one give example?
Last edited by babi_geek; 06-07-2008 at 05:30 AM.
please find a related article here.
Yes we can.
Here is the example
Code:create or replace procedure test_proc is cursor c1 return dept%rowtype is select * from dept where deptno = 10; dept_rec dept%rowtype; begin open c1; fetch c1 into dept_rec; dbms_output.put_line ('department name is ' || dept_rec.dname); close c1; end; /
Last edited by krishnaindia2007; 06-11-2008 at 11:53 PM.
You can specify return type for static cursors. But you can't return a value using static cursors.
Last edited by krishnaindia2007; 06-12-2008 at 12:03 AM.
So far I think return type specification is allowed only for ref cursors.
Then can we define static cursors in package specification part?
>>Then can we define static cursors in package specification part?
Yes you can.
CREATE PACKAGE emp_pkg IS
CURSOR C1 RETURN emp%rowtype ;
.......
END;
/
CREATE OR REPLACE PACKAGE BODY emp_pkg AS
cursor c1 return emp%rowtype is
select * from emp;
.......
END EMP_PKG;
/
Posting Permissions
Reply With Quote