Check error form stored procedure
SQL> CREATE TABLE products(
2 name VARCHAR2(50),
3 pack_size VARCHAR2(30),
4 status VARCHAR2(20),
5 price NUMBER(8,2),
6 min_price NUMBER(8,2)
7 );
Table created.
SQL>
SQL>
SQL> create or replace procedure print_products
2 as
3 declare
4 cursor get_data is select name, price from products;
5 begin
6 for i in get_data
7 LOOP
8 if i.price > 50 then
9 dbms_output.put_line(i.name || ' Price: ' || i.price);
10 else
11 dbms_output.put_line(i.name || ' Product under 50');
12 end if;
13 END LOOP;
14 end;
15 /
Warning: Procedure created with compilation errors.
SQL>
SQL> show errors
Errors for PROCEDURE PRINT_PRODUCTS:
LINE/COL
--------
ERROR
------------------------------------------------------
3/1
PLS-00103: Encountered the symbol "DECLARE" when
expecting one of the following:
begin function package pragma procedure subtype type
use
<an identifier> <a double-quoted delimited-identifier>
form
current cursor external language
The symbol "begin" was substituted for "DECLARE" to
continue.
14/4
PLS-00103: Encountered the symbol "end-of-file" when
expecting one of the following:
begin case declare end exception exit for goto if loop
mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock
insert
open rollback savepoint set sql execute commit forall
merge
Page: 2
LINE/COL
--------
ERROR
------------------------------------------------------
pipe
SQL>
SQL>
SQL> drop table products;
Table dropped.
SQL>
SQL>