Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Fusion Middleware & Colab Suite » Portal & WebCenter Suite » Display a bind variable
Display a bind variable [message #276060] Tue, 23 October 2007 16:06 Go to next message
deahayes3
Messages: 81
Registered: May 2006
Member
I have created a calendar in portal and I would like to execute a query based on the bind variable off the customization form and have the result displayed in one of the points of the Additional Pl/SQl code section. Any ideas.
Report message to a moderator
Re: Display a bind variable [message #276548 is a reply to message #276060 ] Thu, 25 October 2007 08:22 Go to previous message
deahayes3
Messages: 81
Registered: May 2006
Member
I received help with this elsewhere, but in case anyone ever needs to know......

delcare
v_name varchar(25);

BEGIN
v_name:= get_value('p_parameter_name');
if v_name = 'ABC' then
htp.bold('this is the'||v_name||'company');
end if;
END;
Report message to a moderator
Previous Topic:Portal 10G or website
Next Topic:parameter
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 25 17:43:20 CDT 2008

Total time taken to generate the page: 0.05775 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.