|
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; / 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’); |