Can Not Register WSRP V2 Producer Using PLSQL API In Portal 11g (Doc ID 1511447.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Portal - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

Portal 11.1.1.6.0

Can not register WSRP V2 producer using the PLSQL API in Portal 11g.
Using the PLSQL BLOCK below it's possible to register a WSRP V1 producer but not a WSRP V2 producer.

 

Steps To Reproduce:

1. Start a SQLPLUS session connected to the Portal 11G schema
2. Run a PLSQL block to register a WSRP V2 provider:

 set define off
 set serveroutput on

 declare
    lret_integer integer;
    l_provider_rec wwpro_api_provider_registry.provider_record;  
    l_find_rec     wwpro_api_provider_registry.node_provider_record;
 begin
    l_provider_rec.name                 := 'TEST_WSRP_V2';
    l_provider_rec.display_name         := 'TEST_WSRP_V2';
    l_provider_rec.node_id              := null;
    l_provider_rec.timeout              := 100;
    l_provider_rec.timeout_msg          := 'TEST_WSRP_V2 timed out';
    l_provider_rec.implementation_owner := null;
    l_provider_rec.implementation_name := null;
    l_provider_rec.implementation_style :=7;
    l_provider_rec.language             := wwnls_api.AMERICAN;
    l_provider_rec.login_frequency      :=0;
    l_provider_rec.http_url            
 :='http://10.161.221.163:9010/portletapp/portlets/wsrp2?WSDL';

    l_find_rec.id := wwpro_api_provider_registry.register_provider(
         p_provider_rec =>  l_provider_rec  -- IN provider_record  :"the
 record for the provider to be registered"
    );

    dbms_output.put_line('REGISTER_PROVIDER TEST_WSRP_V2' );
    dbms_output.put_line('l_find_rec.ID = '||l_find_rec.ID);

    exception
    when wwctx_api.authentication_exception then
       dbms_output.put_line('ERROR: Authentication failure.');
    when others then
      wwerr_api_error_ui.show_text;
 end;
 /

 
 With WSRP V1 producer it works fine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms