My Oracle Support Banner

Getting PLS-00201,WWC-51000 while running dyamic page using WWSBR_SEARCH_API.SUBMIT_SEARCH (Doc ID 213420.1)

Last updated on APRIL 14, 2025

Applies to:

Portal - Version 3.0.9.8.0 to 9.0.4.3 [Release 9iAS to 10g]
Information in this document applies to any platform.

Symptoms

Created a dynamic page under portal30 schema.
It is using wwsbr_search_api.submit_search with p_search_terms parameter as a bind variable.
Code of dynamic page between ORACLE TAG is something like:

<ORACLE>
BEGIN
  portal30.wwsbr_search_api.submit_search (p_search_terms =>:search, 
  p_search_operator => 'FIND_ANY', p_caid => <CAID>, p_current_caid => <CAID>, 
  p_language =>'us',p_search_for_type => 'ITEMS'); 
END;
</ORACLE>

Getting Page Not Found when Run.
Getting error mentioned below when run under customize option:

ORA-06550: line 1,   column 7:
PLS-00201: identifier 'WWSBR_SEARCH_API.SUBMIT_SEARCH' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (WWV-11230)
The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.1248378949 
(WWC-51000)
The preference path does not exist:ORACLE.WEBVIEW.PARAMETERS.1248378949 
(WWC-51000)

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.