Check error form stored procedure : Compile Error « PL SQL « Oracle PL / SQL






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>

   
    
    
    
  








Related examples in the same category

1.Check the error
2.Check error for procedure
3.PLS-00306: wrong number or types of arguments in call
4.PLS-00363: expression '3' cannot be used as an assignment target
5.Set the PLSQL_WARNING level to DISABLE:ALL
6.This example illustrates the PLS-483 error
7.This package will not compile because the specification and body do not match.
8.Build an anonymous block that will trigger an error.
9.how DDL doesn't work with PL/SQL