Oracle PL/SQL/User Previliege/schema

Use schema in stored procedure

 
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;