set define '^' set verify off prompt ...wwv_flow_web_services Rem Copyright (c) Oracle Corporation 2002. All Rights Reserved. Rem Rem NAME Rem wwv_flow_web_services.sql Rem Rem DESCRIPTION Rem Flow Web Services Rem Rem NOTES Rem Rem INTERNATIONALIZATION Rem unknown Rem Rem MULTI-CUSTOMER Rem unknown Rem Rem SCRIPT ARGUMENTS Rem None Rem Rem RUNTIME DEPLOYMENT: YES Rem Rem MODIFIED (MM/DD/YYYY) Rem jkallman 07/23/2002 - Created Rem jkallman 08/05/2002 - Added parse Rem jkallman 08/07/2002 - Added get_error_code, get_error_message, print_rendered_result Rem jkallman 08/08/2002 - Added parmeters to make_request Rem jkallman 08/09/2002 - Added get_last_error_code, get_last_error_message Rem mhichwa 08/25/2002 - Added grant execute to public Rem jstraub 04/21/2004 - Added UDDI_request, find_proxy, find_services_by_busname, Rem find_services_by_servname, get_service_details, WSDL_analyze, Rem create_web_service to add UDDI browsing and improved web services features. Rem jstraub 04/23/2004 - Added second make_request procedure to support new process type Rem jstraub 05/05/2004 - Added get_path, and append element to dynamically build xpath and request envelope Rem jstraub 05/07/2004 - Added update_process_parms to support updating process of type web service Rem jstraub 05/14/2004 - Significantly changed the way paramaters relate, using ID instead of name, and changed parsing of response Rem jstraub 05/17/2004 - Added p_in_msg_style parameters to generate_body and append_element Rem jstraub 05/17/2004 - Added p_level parameter to get_path to support getting partial paths Rem jstraub 05/20/2004 - Added generate_query Rem jstraub 06/02/2004 - Added generate_header and append_element2 to support soap:header Rem jstraub 08/20/2004 - Added p_type to append_element and append_element2 Rem jstraub 11/16/2006 - Added p_soap_style to create_web_service Rem jstraub 11/17/2006 - Added p_style to generate_envelope Rem jstraub 12/11/2006 - Added p_username and p_password to WSDL_analyze to support basic auth for 11g XDB Web services Rem jstraub 12/12/2006 - Added p_basic_auth to create_web_service to support basic auth for 11g XDB Web services Rem jstraub 12/12/2006 - Added p_username and p_password to function make_request to support basic auth Rem jstraub 12/15/2006 - Added p_wallet_path and p_wallet_pwd to make_request to support SSL (HTTPS) Rem jstraub 12/15/2006 - Added get_wallet_info to support SSL (HTTPS) Rem jstraub 12/22/2006 - Added create_auth_parms for basic auth support Rem jstraub 01/03/2006 - Removed get_wallet_info, no longer necessary since wallet info now platform preference Rem jstraub 01/05/2006 - Added generate_query_manual to support manual web references Rem jstraub 01/16/2009 - Added p_soap_style to append_element, append_element2, generate_body, generate_header (bug 7718753) Rem jstraub 03/27/2009 - Removed p_01 to p_10 parameters from make_request Rem jstraub 03/27/2009 - Removed obsolete generate_envelope functions Rem jstraub 04/02/2009 - Removed obsolete get_error_code, get_error_message, get_last_error_code create or replace package wwv_flow_web_services as -------------------------------------------------- -- globals for response, clob and xmltype -- type flow_soap_response_clob is table of clob index by binary_integer; g_flow_soap_response_clob flow_soap_response_clob; type flow_soap_response_xmltype is table of xmltype index by binary_integer; g_flow_soap_response_xmltype flow_soap_response_xmltype; type flow_soap_idx is table of number index by binary_integer; g_flow_soap_idx flow_soap_idx; g_flow_soap_error_code dbms_sql.varchar2_table; g_flow_soap_error_message dbms_sql.varchar2_table; empty_vc_arr wwv_flow_global.vc_arr2; g_body varchar2(32000); g_header varchar2(32000); function generate_envelope( p_operation in varchar2, p_style in varchar2, p_ns in varchar2, p_body in clob, p_header in clob ) return clob; function make_request( p_url in varchar2, p_action in varchar2, p_envelope in clob, p_username in varchar2, p_password in varchar2, p_proxy_override in varchar2 default null, p_charset in varchar2 default null, p_wallet_path in varchar2, p_wallet_pwd in varchar2 ) return clob; procedure make_request( p_id in number, p_process_id in number, p_charset in varchar2 default null ); procedure make_request( p_id in number, p_operation_id in number, p_process_id in number, p_charset in varchar2 default null ); function render_request( p_service_id in number, p_stylesheet in clob default null, p_occurrence in number default 1, p_stylesheet_id in number default null) return clob; procedure print_rendered_result( p_service_id in number, p_stylesheet in clob default null, p_occurrence in number default 1, p_stylesheet_id in number default null ); function parse( p_clob in clob ) return clob ; function get_last_error_message return varchar2; function find_proxy( p_flow_id in varchar2) return varchar2; function get_parm_value( p_parm_id in number, p_process_id in number ) return varchar2; function get_parm_value( p_name in varchar2, p_parm_name in wwv_flow_global.vc_arr2 default empty_vc_arr, p_parm_value in wwv_flow_global.vc_arr2 default empty_vc_arr ) return varchar2; procedure append_element( p_process_id in number default null, p_parm_id in number, p_name in varchar2, p_is_xsd in varchar2, p_type in varchar2, p_operation_id in number, p_in_msg_style in varchar2, p_soap_style in varchar2, p_parm_name in wwv_flow_global.vc_arr2 default empty_vc_arr, p_parm_value in wwv_flow_global.vc_arr2 default empty_vc_arr ); procedure append_element2( p_process_id in number default null, p_parm_id in number, p_name in varchar2, p_is_xsd in varchar2, p_type in varchar2, p_operation_id in number, p_in_msg_style in varchar2, p_ns in varchar2, p_soap_style in varchar2, p_parm_name in wwv_flow_global.vc_arr2 default empty_vc_arr, p_parm_value in wwv_flow_global.vc_arr2 default empty_vc_arr ); procedure generate_body( p_process_id in number default null, p_operation_id in number, p_in_msg_style in varchar2, p_soap_style in varchar2, p_parm_name in wwv_flow_global.vc_arr2 default empty_vc_arr, p_parm_value in wwv_flow_global.vc_arr2 default empty_vc_arr ); procedure generate_header( p_process_id in number default null, p_operation_id in number, p_in_msg_style in varchar2, p_ns in varchar2, p_soap_style in varchar2, p_parm_name in wwv_flow_global.vc_arr2 default empty_vc_arr, p_parm_value in wwv_flow_global.vc_arr2 default empty_vc_arr ); function get_path( p_parm_id in number, p_level in number default 0 ) return varchar2; function generate_query( p_operation_id in number, p_array_parm in number, p_report_collection_name in varchar2, p_array_parms_collection in varchar2 ) return varchar2; function generate_query_manual( p_result_node in varchar2, p_soap_style in varchar2, p_message_format in varchar2, p_namespace in varchar2, p_report_collection_name in varchar2, p_array_parms_collection in varchar2 ) return varchar2; function UDDI_request( p_uddi_url in varchar2, p_request_type in varchar2, p_request_parameter in varchar2, p_proxy_url in varchar2, p_request_parameter2 in varchar2 default null, p_uddi_version in varchar2 default '2.0' ) return xmltype; procedure find_services_by_servname( p_uddi_url in varchar2, p_request_parameter2 in varchar2, p_flow_id in varchar2, p_services_collection in varchar2, p_exact in varchar2 default 'N', p_case_sensitive in varchar2 default 'N', p_uddi_version in varchar2 default '2.0' ); procedure find_services_by_busname( p_uddi_url in varchar2, p_request_parameter in varchar2, p_flow_id in varchar2, p_services_collection in varchar2, p_exact in varchar2 default 'N', p_case_sensitive in varchar2 default 'N', p_uddi_version in varchar2 default '2.0' ); procedure get_service_details( p_uddi_url in varchar2, p_request_parameter in varchar2, p_flow_id in varchar2, p_services_collection in varchar2, p_details_collection in varchar2, p_uddi_version in varchar2 default '2.0' ); function WSDL_analyze( p_wsdl_url in varchar2, p_flow_id in varchar2, p_uddi_details_collection in varchar2, p_web_service_collection in varchar2, p_operations_collection in varchar2, p_inputs_collection in varchar2, p_outputs_collection in varchar2, p_username in varchar2, p_password in varchar2 ) return varchar2; procedure create_web_service( p_id in number, p_flow_id in varchar2, p_name in varchar2, p_url in varchar2, p_target_ns in varchar2, p_xsd_prefix in varchar2, p_soap_style in varchar2, p_operations_collection in varchar2, p_inputs_collection in varchar2, p_outputs_collection in varchar2, p_basic_auth in varchar2 ); procedure update_process_parms( p_process_id in number, p_in_parm_ids in wwv_flow_global.vc_arr2, p_in_parm_map_types in wwv_flow_global.vc_arr2, p_in_parm_values in wwv_flow_global.vc_arr2, p_out_map_type in varchar2, p_out_parm_ids in wwv_flow_global.vc_arr2, p_out_parm_values in wwv_flow_global.vc_arr2, p_auth_parm_ids in wwv_flow_global.vc_arr2, p_auth_parm_map_types in wwv_flow_global.vc_arr2, p_auth_parm_values in wwv_flow_global.vc_arr2 ); procedure create_process_parms( p_process_id in number, p_in_parm_collection_name in varchar2, p_out_map_type in varchar2, p_out_parm_collection_name in varchar2 ); procedure create_auth_parms( p_process_id in number, p_auth_collection_name in varchar2 ); end wwv_flow_web_services; / show errors