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 and later
Information in this document applies to any platform.



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

    lret_integer integer;
    l_provider_rec wwpro_api_provider_registry.provider_record;  
    l_find_rec     wwpro_api_provider_registry.node_provider_record;
 begin                 := '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;
 :=''; := 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);

    when wwctx_api.authentication_exception then
       dbms_output.put_line('ERROR: Authentication failure.');
    when others then

 With WSRP V1 producer it works fine.


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