OWA_UTIL ওরাকল ডাটাবেজের ইউটিলিটি প্যাকেজ। এর একটি সাব প্রোগ্রাম হলো GET_CGI_ENV, এর মাধ্যমে ইউজারের আইপি, ডিভাইস ইনফো সহ অনেক কিছু পেতে পারি।

syntax:

owa_util.get_cgi_env(parameter_name in varchar2) return varchar2;

যে সকল প্যারামিটার দিয়ে আমরা GET_CGI_ENV কে কল করতে পারি –

  1. PLSQL_GATEWAY
  2. GATEWAY_IVERSION
  3. SERVER_SOFTWARE
  4. GATEWAY_INTERFACE
  5. SERVER_PORT
  6. SERVER_NAME
  7. REQUEST_METHOD
  8. PATH_INFO
  9. SCRIPT_NAME
  10. REMOTE_ADDR
  11. SERVER_PROTOCOL
  12. REQUEST_PROTOCOL
  13. REMOTE_USER
  14. HTTP_CONTENT_LENGTH
  15. HTTP_CONTENT_TYPE
  16. HTTP_USER_AGENT
  17. HTTP_HOST
  18. HTTP_ACCEPT
  19. HTTP_ACCEPT_ENCODING
  20. HTTP_ACCEPT_LANGUAGE
  21. HTTP_REFERER
  22. HTTP_ORACLE_ECID
  23. WEB_AUTHENT_PREFIX
  24. DAD_NAME
  25. DOC_ACCESS_PATH
  26. DOCUMENT_TABLE
  27. PATH_ALIAS
  28. REQUEST_CHARSET
  29. REQUEST_IANA_CHARSET
  30. SCRIPT_PREFIX
  31. HTTP_COOKIE

Example:

DECLARE 
    l_resp VARCHAR2(100); 
BEGIN 
    --get value 
    l_resp := OWA_UTIL.get_cgi_env('REQUEST_PROTOCOL'); 
    
    --print output 
    HTP.print (l_resp); 
END;

Sample output:

PLSQL_GATEWAY : WebDb 
GATEWAY_IVERSION : 3 
SERVER_SOFTWARE : Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server
GATEWAY_INTERFACE : CGI/1.1
SERVER_PORT : 7780
SERVER_NAME : dummyserver
REQUEST_METHOD : POST
PATH_INFO : /wwv_flow.show
SCRIPT_NAME : /pls/dmt
REMOTE_ADDR : 148.132.152.59
SERVER_PROTOCOL : HTTP/1.1
REQUEST_PROTOCOL : HTTP
REMOTE_USER : APEX_PUBLIC_USER
HTTP_CONTENT_LENGTH : 416
HTTP_CONTENT_TYPE : application/x-www-form-urlencoded
HTTP_USER_AGENT : Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
HTTP_HOST : dummyserver.com.au:7780
HTTP_ACCEPT : */*
HTTP_ACCEPT_ENCODING : gzip, deflate
HTTP_ACCEPT_LANGUAGE : en-au
HTTP_REFERER : http://dummyserver.com.au:7780/pls/dmt/f?p=4500:1003:4479870342920497::NO:::
HTTP_ORACLE_ECID : 1297402712:144.135.172.44:22243:0:21186,0
WEB_AUTHENT_PREFIX : 
DAD_NAME : dmt
DOC_ACCESS_PATH : docs
DOCUMENT_TABLE : wwv_flow_file_objects$
PATH_ALIAS :
REQUEST_CHARSET : UTF8
REQUEST_IANA_CHARSET : UTF-8
SCRIPT_PREFIX : /pls
HTTP_COOKIE : ISCOOKIE=true; LOGIN_USERNAME_COOKIE=U123456; LOGIN_PASSWORD_COOKIE=; LOGIN_REMEMBER_ME_COOKIE=; r1=%23ALL; r2=%23ALL; r3=%23ALL; propHide=4301%2C%23ALL; WWV_FLOW_USER2=47770A7FD83D3E0A; ORACLE_PLATFORM_REMEMBER_UN=U123456:dmt; __ppFullPath=di-di; s_nr=1296902947468; s_evar18=%5B%5B%27referral%27%2C%271296902515781%27%5D%5D; SearchSettings=50,0,0,1,1,1,1,1; HTMLDB_IDLE_SESSION=11-FEB-2011 10:22:00; WWV_CUSTOM-F_955908081711180_100=739B959ED77BAFE2