| drop table coffee; | |
| drop procedure COUNTCOFFEE; | |
| drop procedure INSERTCOFFEE; | |
| create table coffee (name varchar(32), qty integer); | |
| create or replace procedure COUNTCOFFEE (N OUT INTEGER) is | |
| begin select count(*) into N from coffee; | |
| end; | |
| / | |
| create or replace procedure INSERTCOFFEE (name IN VARCHAR2, qty IN INTEGER) is | |
| begin insert into coffee values (name, qty); | |
| end; | |
| / |