Newbie PL/SQL script question?mlml

From: Michel Lee <ae299_at_FreeNet.Carleton.CA>
Date: 1998/02/27
Message-ID: <6d51j0$7v@freenet-news.carleton.ca>#1/1

This problem has been bugging me for 1 whole day! Please can u help me with this trivial question.

If I run the below script (i am running as SYSTEM), i get this message:

Warning: Procedure created with compilation errors.

CREATE PROCEDURE myspace AS
CURSOR datafile2 IS
SELECT name, bytes
FROM v$datafile;
BEGIN

DBMS_OUTPUT.PUT_LINE('-----------------------------------');

END myspace;
/

If I run this script, it runs with NO 'Warning' messages

CREATE PROCEDURE myspace AS
CURSOR datafile2 IS
SELECT 1 from dual;
BEGIN

DBMS_OUTPUT.PUT_LINE('-----------------------------------');

END myspace;
/

Whats the diff?
Obviously I am trying to get the 1st to run. I tried just run the select portion by itself in the commandline, and it works.
Where can i get a more detailed 'Warning' message?

cheers
Mike

--
    /-----------------------------------------------/ \--\--\  \-- \-- \--
   /             www.ncf.carleton.ca/~ae299        /---\  \  \ \\   \   \
  /             ae299_at_freenet.carleton.ca         /-----\     \ \\-- \-- \--
 /-----------------------------------------------/

Received on Fri Feb 27 1998 - 00:00:00 CST