CREATE OR REPLACE PACKAGE KRISHNA_PKG AS PROCEDURE MyProcedure; END KRISHNA_PKG; / CREATE OR REPLACE package body krishna_pkg is procedure MyProcedure as begin dbms_session.set_context( 'KRISHNA_CTX', 'SURNAME','Test'); end MyProcedure; end krishna_pkg; /