• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1543
  • Last Modified:

How to get page parameter pass to portlet.

In Oracle Portal , I have page parameter value as bind variable. ex. :commID and default value is 1.
How can I pass this parameter to portlet to make my portlet has dynamic content generated based on this bind variable?  Any PLSQL API Available?
1 Solution
Mayank SAssociate Director - Product EngineeringCommented:
You can't talk to a portlet via PL/ SQL API. What exactly are you looking for?
Mayank SAssociate Director - Product EngineeringCommented:
bind variable can be assigned a value in Your portlet and can be transfered into an environment variable,defined at PLSQL session level.I'm not sure how it's for Portal but in SQLPLUS it would work like that:
var myv varchar2(50)
CliffEngelWirtAuthor Commented:
I have page parameter for my page, but I don't know how to pass the value of the page parameter to the portlet inside the page.  I think there may be any API I can use.
The way to do it depends on what type of portlet you have.
If you have a custom PL/SQL portlet, you can NOT get the page parameter value Unless a value is provided through the URL.
You can use this code top get some URL parameter:
htp.p( 'Parameter: '||wwpro_api_parameters.get_value(p_name => 'p_parameter',p_reference_path => p_portlet_record.reference_path));
where the name of the URL parameter is p_parameter.

You can get the page parameter value even when it is defaulted only in java portlets or in a locally built provider (e.g. dynamic page) by defining a parameter in that portlet.
This is done (in a dynamic page) like this:
htp.p( 'Parameter: '||:parameter1);

At the page properties, you must map the page parameter to the portlet parameter.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now