create table sprockets ( id number, description varchar2(200), quantity number ) / create or replace procedure add_sprocket as begin insert into george.sprockets values( 6, 'Aluminum', 10 ); end; / drop table sprockets;