UTL_HTTP
529371Aug 22 2006 — edited Aug 24 2006Hi,
i need advice.
utl_http.set_body_charset('ISO-8859-2');
http_req := utl_http.begin_request(x_url, 'POST', 'HTTP/1.0');
utl_http.set_header(http_req, 'Content-Type', 'text/xml');
utl_http.set_header(http_req, 'Content-Length', length(env));
utl_http.set_header(http_req, 'SOAPAction', action);
dbms_output.put_line('postupne odosleme request');
procstep := 'postupne odosleme request';
offset := 1;
LOOP
env2 := dbms_lob.substr(env, amount, offset);
EXIT WHEN env2 IS NULL;
offset := offset + amount;
utl_http.write_text(http_req, env2);
END LOOP;
http_resp := utl_http.get_response(http_req);
resp.doc := NULL;
BEGIN
LOOP
j:=j+1;
utl_http.read_text(http_resp, env2);
resp.doc := resp.doc || env2;
END LOOP;
EXCEPTION
WHEN
OTHERS THEN
NULL;
END;
utl_http.end_response(http_resp);
this code works on 2 databases but don't work on third
each database have nls_charset ee8iso8859p2
can anyone help me.
OWA_UTIL.print_cgi_env;
WEB_AUTHENT_PREFIX =
DAD_NAME = orcl
DOC_ACCESS_PATH =
DOCUMENT_TABLE = UPLOADED_FILES
PATH_INFO = /w_test.banner_new.main
SCRIPT_NAME = /pls/orcl
PATH_ALIAS =
REQUEST_CHARSET = EE8ISO8859P2
REQUEST_IANA_CHARSET = ISO-8859-2
SCRIPT_PREFIX = /pls
PLSQL_GATEWAY = WebDb
GATEWAY_IVERSION = 2
SERVER_SOFTWARE = Oracle HTTP Server Powered by Apache/1.3.22 (Unix) mod_plsql/3.0.9.8.3b mod_fastcgi/2.2.12 mod_perl/1.25 mod_oprocmgr/1.0
GATEWAY_INTERFACE = CGI/1.1
SERVER_PORT = 7777
SERVER_NAME = localhost.localdomain
REQUEST_METHOD = GET
REMOTE_ADDR = 10.9.8.57
SERVER_PROTOCOL = HTTP/1.1
REQUEST_PROTOCOL = HTTP
HTTP_USER_AGENT = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7
HTTP_HOST = kryton.ba.dynatech.sk:7777
HTTP_ACCEPT = text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING = gzip,deflate
HTTP_ACCEPT_LANGUAGE = en-us,en;q=0.5
HTTP_ACCEPT_CHARSET = ISO-8859-1,utf-8;q=0.7,*;q=0.7
but on one server which this code dont work has
REQUEST_CHARSET = EE8MSWIN1250
REQUEST_IANA_CHARSET = WINDOWS-1250
can be it?
how can i change this setting?