create or replace procedure sample_plsql_app.sample_proc as l_user varchar(255) := owa_util.get_cgi_env('REMOTE_USER'); begin htp.prn('<h1>Hello ' || l_user || '!</h1>'); end; /