PL/SQL anonymous procedure

Hi I am using ORACLE7 R 7.0.15.4.0 and PL/SQL R 2.0.17.1.0 on HP workstation.

I have the following code stored in a .sql file:

--

declare

    --
    cursor my_cur is select * from my_tab;     --
    type my_rec is record

        (
        name db_tab.name%type,
        age db_tab.age%type,
        sex db_tab.sex%type,
        height db_tab.height%type,
        weight db_tab.weight%type
        );

    open my_cur;
--

• code deleted
  --
  close my_cur; commit work; end; /

When I issue 'SQL> _at_myfile.sql' I get the following error:

declare
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at line 61 (ie. end of file)

Could someone enlighten me with the cause of this error?

Thanks in advance.

Long
Ottawa Received on Tue Jul 12 1994 - 20:40:51 CEST