Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rookie question

Rookie question

From: rsenn <rsenn_at_capaccess.org>
Date: 1997/10/16
Message-ID: <3446B880.7EA9F732@capaccess.org>#1/1

Can anybody tell me why these statements are generating errors?   Thanks.

SQL> create or replace procedure test
  2 is
  3 begin
  4 select * from emp_hist ;
  5 end test ;
  6 /

Warning: Procedure created with compilation errors.

SQL> create or replace procedure test
  2 (v_dummy out number)
  3 is
  4 begin
  5 select * from emp_hist ;
  6 end test ;
  7 /

Warning: Procedure created with compilation errors. Received on Thu Oct 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US