UNABLE TO GENERATE WRAPPER FROM AN SP WHEN IT BELONGS TO A DIFFERENT USER (Doc ID 1315366.1)

Last updated on APRIL 21, 2011

Applies to:

Oracle SOA Platform - Version: 11.1.1.3.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms


  • In JDeveloper you create a DataBase (DB) connection to schema A
  • Schema A has privileges over a stored procedure in schema B
  • In the DB wizard of JDeveloper you select the procedure from schema B,
    but the wizard tries to create WSDL looking for procedure in schema A and throws the following error, even if it has privileges over schema B:

    Error
    Error while wrting wsdl file
    c:\Jdeveloper\mywork\Application11\project1\testdb1.wsdl Exception:
    WSDL Exception: faultCode=OTHER_ERROR: The wrapper procedure,
    TESTGENERICPACKAGE$GENE, could not be found in the package,
    BPEL_TESTDB1, for the schema, USERA

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