WWC-51000 Error when Executing a Remote Procedure using HTP.P (Doc ID 293952.1)

Last updated on AUGUST 15, 2016

Applies to:

Portal - Version 9.0.4 to 10.1.4.2 [Release 10g to 10gR2]
Information in this document applies to any platform.
Checked for relevance on 03-Mar-2015


Symptoms

Unable to execute a remote Procedure (residing in a remote database) that displays data using HTP.P package.
Following error is reported when the Procedure is executed.

ORA-6502: PL/SQL: numeric or value error
ORA-6512: at "SYS.OWA_UTIL", line 325
ORA-6512: at "SYS.HTP", line 1201
ORA-6512: at "SYS.HTP", line 1496
ORA-6512: at "SYS.HTP", line 1513
ORA-6512: at "HES_PORTAL.TEST_DYN", line 14 (WWV-11230)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.3643765043 (WWC-51000)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.3643765043
(WWC-51000)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.3643765043
(WWC-51000)

Changes

Remote Database

/* Procedure in the remote database */
CREATE OR REPLACE PROCEDURE scott.hellome AS
 BEGIN
   htp.p('Hello World');
 END;

/* Grant execute privileges on the Procedure */
GRANT EXECUTE ON scott.HelloMe TO PUBLIC;


Local Database (where Portal repository resides)

/* Create a PUBLIC Database Link to the remote database */
CREATE PUBLIC DATABASE LINK myDBLink CONNECT TO scott IDENTIFIED BY tiger;

/* Create a PUBLIC Synonym to access the object in the remote database */
CREATE PUBLIC SYNONYM RemoteHelloMe FOR scott.HelloMe@myDBLink;


Execute the remote Procedure from the local database. This can be done via a Dynamic Page or a PLSQL Item. Snippet of code to execute the Procedure:

BEGIN
 RemoteHelloMe;
END;


Above mentioned error is displayed.

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