create [or replace] procedure procedure_name (varible {IN|OUT|IN OUT} type){IS|AS} [varible { in | out | in out }]type;[varible { in | out | in out }] type;...... [cursor curor_name IS select subclause] begin body end [procedure_name]; for example: create or replace procedure sp_logi...