the pl/sql engine is part of the database 
(I'm not speaking about client side pl/sql in 
forms etc). As such, you need to have access to
 a database then you can compile.
 From sqlplus:
 SQL> CREATE TABLE T ( 
   2    COL1  VARCHAR2 (80));
 Table created.
 SQL> create or replace procedure p  is
   2  begin
   3  insert into t values('hello world '||sysdate);
   4  end p;
   5  /
 Procedure created.
 SQL> show errors
 No errors.
 SQL>