Conference orarep::nomahs::rdb_60

5065.0. "STORED PROCEDURES - AND CURSOR OPERATIONS" by ORAREP::QCAV01::KRISH () Mon Feb 24 1997 03:05

    
Hi,
    
    I am using Oracle -RDB 7.1 running in Open VMS 7.1 on Alpha.
    I am facing a problem when i am trying to do cursor operations in
    stored procedures.
    When i try to compile the  the module containg the following stored 
    procedures i am getting the following error,
    
    %SQL-F-LOOK-FOR, syntax error, 
    looking for :, found LST_TEST_CUR
    
    And i also getting  a informational message saying that OPEN is  a
     deprecated feature.
    
    Please help me in this regard
    
    Thanks in advance.
    
    With regards
    S.Krishnakumar
    
    
    
    
Create module test_mod
language sql
DECLARE  
    LST_TEST_CUR  READ ONLY CURSOR FOR
	SELECT	EMP_NO
	FROM    EMP
	ORDER BY EMP_NO


procedure open_lst_test_cur();
begin
	OPEN LST_TEST_CUR; 
end;


procedure fetch_lst_test_cur(
	out :emp_no int);
begin
    FETCH LST_TEST_CUR INTO
		:emp_no;
end;	


procedure close_lst_test_cur();
begin
	CLOSE LST_TEST_CUR;
end;

end module;

>    I am using Oracle -RDB 7.1 running in Open VMS 7.1 on Alpha.
    
    I doubt that. The latest version of Oracle Rdb is 7.0.
    
>Create module test_mod
>language sql
>DECLARE  
>    LST_TEST_CUR  READ ONLY CURSOR FOR
>	SELECT	EMP_NO
>	FROM    EMP
>	ORDER BY EMP_NO
    
    According to the SQL Reference Manual's description of CREATE MODULE
    the only declare statements that can be used are DECLARE TRANSACTION,
    or DECLARE LOCAL TEMPORARY TABLE. Declaring a cursor is not allowed.
    
    Peter

The support for cursors is planned for a future version.

Ian