-- procedure.sql
-- Procedure - Skeleton of a procedure
--

create or replace
PROCEDURE DBSTARuser.p_test
--      Enter the parameters for the procedure in the brackets above.  If this procedure has
--      no parameters. Example: PROCEDURE schema.test(variable2 in varchar2, variable3 in varchar2)
--
--       ***************************************************
--       *   
--       *   Author 
--       *   Creation Date 
--       *   Comments      
--       *                 
--       ***************************************************
IS
var1 varchar(10) := 'xxx';

begin
   var1:='test';
        
--      Enter the code for the procedure following right here


exception
--      Enter the code to handle exception conditions right here
when others then
   null;
                        
end;
/