MemoSoup

Mix of the things I always forget

Oracle: checksum function for strings

Posted on 17/11/2011 by bigspoon

[cc lang=”plsql”]
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;
/
[/cc]

Perl: SOAP problem with dateTime

Posted on 10/11/2011 by bigspoon

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:

[cc lang=”Perl”]
my $soap = SOAP::Lite->uri( $NAMESPACE )->proxy( $PROXY_URL )->xmlschema (‘2001’);
[/cc]