Home » Developer & Programmer » Forms » Passing parameters from JSP to Oracle forms.. (Oracle 10g forms)
Passing parameters from JSP to Oracle forms.. [message #385271] Sun, 08 February 2009 20:28 Go to next message
urnikhil
Messages: 42
Registered: March 2008
Member
Hi all,

I would like to know how we can pass parameters from a jsp page to Oracle forms.

Any guidance on this is greatly appreciated.

Thanks,
Nikhil.
Re: Passing parameters from JSP to Oracle forms.. [message #385504 is a reply to message #385271] Mon, 09 February 2009 23:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do not cross-post your messages!!

Search this site for 'pass parameters from a jsp page to Oracle forms'. Then 'google' the same.

David
Re: Passing parameters from JSP to Oracle forms.. [message #385506 is a reply to message #385271] Mon, 09 February 2009 23:25 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
hi david,

Thanks for your reply. I did search this website before and all I found was similar questions but did not find a specific reply.

I did google, wasn't lucky there too. So thought anyone here can help me out.

Thanks,
Nikhil.
Re: Passing parameters from JSP to Oracle forms.. [message #385516 is a reply to message #385506] Tue, 10 February 2009 00:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Google returned http://oracle.anilpassi.com/call-oa-framework-page-from-oracle-forms-passing-parameters-2.html and http://www.oracle.com/technology/pub/articles/wilfred-adf-forms.html

The later contains:
Quote:
Getting Context into Oracle Forms
The legacy lifecycle feature introduces a problem when passing context from the Web application to Oracle Forms. What if you want to incorporate an Oracle Forms form to edit an order in an Oracle ADF Faces page? You probably want to pass the selected order ID from the Oracle ADF Faces application to Oracle Forms. Again, you cannot do this the typical way by adding the parameter in the HTML to include the Oracle Forms applet. This would mean different HTML for each order and would defeat the reuse of the suspended applet.

Once more , you can work around this issue with the outbound JavaScript API. You can incorporate the order ID (or whatever context you want to pass) as an invisible item on the Oracle ADF Faces pages. The Oracle Forms form can inspect this value during the WHEN-NEW-FORM-INSTANCE trigger and act accordingly:
declare
  orderID  number;
begin
  -- get the order ID
  set_custom_property('BLK_PJC.PJC', 1, 'EvalExpression', 
    'document.getElementById(''frm:orderID'').value');
  customerID := get_custom_property('BLK_PJC.PJC', 1, 'EvalResult');
  :parameter.ordid:=orderID;
  -- execute query (where clause refers :parameter.ordid)
  do_key('execute_query');
end;


David
Previous Topic: How to know if user has updated a field...
Next Topic: Forms column - reports row ????
Goto Forum:
  


Current Time: Wed Dec 07 06:39:46 CST 2016

Total time taken to generate the page: 0.19999 seconds