Databases
StackOverflow2013
Postsdbo
POpassing parameters between a psp and a html page
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpassing parameters between a psp and a html page
    text
    copied!<p>i have a psp(plsql server page) to which a parameter called p_user_name is passed as shown below:</p> <p>i have created a local variable called p_user in the page as shown below:</p> <pre><code>&lt;%@ plsql procedure="recon_portal" %&gt; &lt;%@ plsql parameter="p_menu" type="varchar2" default="'home'" %&gt; &lt;%@ plsql parameter="p_rpt_CI" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="p_conv_CI" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="p_rpt_CI_run" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="p_conv_name" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="file_path1" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="file_path2" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="file_path3" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="file_path4" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="file_path5" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="file_path6" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="conv" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="p_pass_inst" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="p_pass_dir" type="varchar2" default="NULL" %&gt; &lt;%@ plsql parameter="p_user_name" type="varchar2" default="NULL" %&gt; &lt;%! lv_report_file_name ci_ref_list.report_file_name%TYPE; lv_ci_desc_file_name ci_ref_list.ci_desc_file_name%TYPE; file_path varchar(100); file_path_master varchar(100); file_path_linked varchar(100); url_path varchar(100); lv_conv varchar(100); lv_ci_ref varchar(100); lv_conv_name varchar(100); lv_ci_run varchar(100); lv_instance_name varchar(100); lv_doc varchar(100); lv_display_name varchar(200); p_user varchar(100); %&gt; </code></pre> <p>at some part of program i query a value from backend and put it into p_user as below:</p> <pre><code>&lt;% BEGIN select 'Super User' into p_user from fnd_user fndusr where fndusr.user_id = fnd_global.user_id and exists (SELECT 1 FROM fnd_lookup_values flv WHERE flv.lookup_type = 'IKN_RAC_RECON_SUPER_USERS' AND flv.lookup_code = fndusr.user_name); EXCEPTION WHEN OTHERS THEN p_user := 'Basic User'; END; %&gt; </code></pre> <p>some html files are included at the end in my psp page as shown below:</p> <pre><code>&lt;%ELSIF p_menu = 'conv' THEN %&gt; &lt;%@ include file="recon_conversions.html" %&gt; &lt;%ELSIF p_menu = 'rept' THEN %&gt; &lt;%@ include file="recon_reports.html" %&gt; &lt;%ELSE%&gt; &lt;%@ include file="recon_docs.html" %&gt; &lt;%END IF;%&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>now in these html files i need to use the value which is in the parameter p_user. is there any way to get the value of p_user in those html files?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload