web analytics

Oracle: checksum function for strings

CREATE OR REPLACE FUNCTION get_checksum(source_string IN VARCHAR) RETURN VARCHAR IS   raw_string RAW(2048);   result     RAW(2048); BEGIN   raw_string := utl_i18n.string_to_raw(source_string);   result := sys.dbms_crypto.hash(raw_string, sys.dbms_crypto.hash_sh1);   RETURN result ; END; /

Perl: SOAP problem with dateTime

The following error message was received by Perl application: Unrecognized type ‘{http://www.w3.org/1999/XMLSchema}dateTime

The problem is caused by “dateTime” type: it was not supported in the 1999 XML Specification. The solution is to switch to 2001 schema:

 my $soap = SOAP::Lite->uri( $NAMESPACE )->proxy( $PROXY_URL )->xmlschema (’2001’);