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

Home -> Community -> Usenet -> c.d.o.server -> 2 similar statements, one works, one doesn't. Why?

2 similar statements, one works, one doesn't. Why?

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

Gentle readers, can someone tell me why one of these statements works and the other
doesn't ? Thanks.

SQL> create or replace procedure test
  2 is
  3 begin
  4 update emp_hist
  5 set id = 13
  6 where id = 9999 ;
  7 end test ;
  8 /

Procedure created.

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

  5    -- update emp_hist
  6    -- set id = 13
  7    -- where id = 9999 ;

  8 end test ;
  9 /

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