newbie: how to use packages

From: Arthur Habraken <duri_at_xs4all.nl>
Date: 1998/01/15
Message-ID: <69koki$59b$1@news2.xs4all.nl>#1/1

I'm trying to learn PL/SQL and I installed Personal Oracle 7 on my PC. No I'd like to use UTL_FILE-functions, but it doesn't work. I'm trying to output the contents of an ASCII-file to my screen using PL/SQL with the following code :

declare
  f UTL_FILE.FILE_TYPE;
  b varchar2(1022);
begin
  f := utl_file.fopen('c:\autoexec.bat', 'r');   loop
    begin

      utl_file.get_line(f,b);
      dbms_output.put_line(b);

      exception
        when no_data_found then
          exit;

    end;
  end loop;
  utl_file.fclose(f);
end;
/

When I try to execute this, I get this :

declare
 *
ERROR at line 1:

ORA-06550: line 2, column 6:
PLS-00201: identifier 'UTL_FILE.FILE_TYPE' must be declared
ORA-06550: line 2, column 6:

PL/SQL: Item ignored
ORA-06550: line 5, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored
ORA-06550: line 8, column 25:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 8, column 7:
PL/SQL: Statement ignored
ORA-06550: line 15, column 19:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 15, column 3:
PL/SQL: Statement ignored

What is going on ? Can anybody help me out please ?

Thanks in advance,

Arthur Habraken
duri_at_xs4all.nl Received on Thu Jan 15 1998 - 00:00:00 CST