1 package OWA is
2 PRAGMA RESTRICT_REFERENCES(owa, WNDS, RNDS, WNPS, RNPS);
3
4 type vc_arr is table of varchar2(32000) index by binary_integer;
5 type nc_arr is table of nvarchar2(16000) index by binary_integer;
6 type raw_arr is table of raw(32000) index by binary_integer;
7
8 cgi_var_name vc_arr;
9 cgi_var_val vc_arr;
10 num_cgi_vars number;
11
12 NL_CHAR constant varchar2(1) := owa_cx.nl_char;
13 SP_CHAR constant varchar2(1) := owa_cx.sp_char;
14 BS_CHAR constant varchar2(1) := owa_cx.bs_char;
15 HT_CHAR constant varchar2(1) := owa_cx.ht_char;
16 XP_CHAR constant varchar2(1) := owa_cx.xp_char;
17
18 auth_scheme integer;
19 protection_realm varchar2(255);
20 user_id varchar2(255);
21 password varchar2(255);
22 ip_address owa_util.ip_address;
23 hostname varchar2(255);
24
25 /*******************************************************************/
26 /* Initialize function - */
27 /* This function is called when a DCD is invoked for the first */
28 /* time when PL/SQL Agent starts up. */
29 /*******************************************************************/
30 function initialize return integer;
31
32 /********************************************/
33 /* Initialize the CGI environment variables */
34 /********************************************/
35 procedure init_cgi_env (param_val in vc_arr);
36 procedure init_cgi_env (num_params in number,
37 param_name in vc_arr,
38 param_val in vc_arr);
39
40 /*****************************************/
41 /* Get the output from the user's PL/SQL */
42 /*****************************************/
43 function get_line (irows out integer) return varchar2;
44 procedure get_page (thepage out NOCOPY htp.htbuf_arr,
45 irows in out integer );
46 /* Start of OAS specific helper procedures */
47 procedure get_page_charset_convert (thepage out NOCOPY htp.htbuf_arr,
48 irows in out integer ,
49 charset in varchar2 );
50 /* End of OAS specific helper procedures */
51
52 /* The raw interface to match HTP */
53 procedure get_page_raw (thepage out NOCOPY htp.htraw_arr,
54 irows in out integer);
55
56 procedure reset_get_page;
57
58 /* Set package globals */
59 procedure set_user_id(usr in varchar2);
60 procedure set_password(pwd in varchar2);
61
62 /* Enable raw transfer mode */
63 procedure set_transfer_mode(tmode in varchar2);
64 end;