Hi Sir, I have a question about a function that I call in a before-header process to redirect to the appropriate page. create or replace function redirect_page(p_user_name in varchar2) return varchar2 as v_redirect_url varchar2(100); branch_page table_1.PAGE%type; v_state table_1.STATE%type; v_finalpaper_id table_1.fpid%type; begin begin select fp.state, fp.page,fp.id into v_state, branch_page,v_id from table_1 fp left outer join users u on u.uuid=fp.uuid where lower(u.username)=lower(p_user_name); if v_state ='REQUESTED'then v_redirect_url:='f?p=100:95:&APP_SESSION.::NO::P95_ID:'||v_id; elsif v_state ='APPROVED'then v_redirect_url:='f?p=100:92:&APP_SESSION.::NO::P92_ID:'||v_id; end if; exception when no_data_found then v_redirect_url:='f?p=100:1:&APP_SESSION.::NO::'; end; return v_redirect_url; end; Now, when I call the function in the page, I get the 500 Internal Server Error DECLARE v_redirect_url VARCHAR2(100); BEGIN v_redirect_url:=redirect_page_finalpapers(:session_user_name); htp.init(); owa_util.redirect_url(v_redirect_url); apex_application.g_unrecoverable_error := true; END; I don't quite understand why this happening and would appreciate some help on here?
In Oracle Apex, in master-detail form, my detail is interactive Grid I want calculation on runtime like when I give some value in the amount column in the first row then add a row and again I input some value in the amount column both rows some show in page item in master on runtime
Hi Vinish i'm trying to create master detail form manually in Oracle Apex 21.1 There is a physical relation between two tables in Database . 1- i have created master region (type : Form)and switch on Primary key Column 2- after that i added a new region(type : IG) , but here in Master Detail property i can not see other region shown in list ... Please tell me what is missing ,
I have an Editable Interactive Grid and a Classic Report in my page. Requirement : A classic report region should be shown when the compliance_code value is selected as "ESCALATION" in the Interactive Grid. Note: Unless and until the compliance_code value = "ESCALATION" exists in the Interactive Grid list, the Classic Report region should be visible. Once it is changed or not in list, the Classic Report region should be hidden. On clicking a Add Row button a new row will be displayed with 4 columns.(compliance_code(Select List value), Reason, Notes, Remarks) By selecting the below values, Row 1. Compliance_code = "Testing" Row 2. Compliance_code = "ESCALATION" Now the classic report region gets displayed. On clicking Add Row for the next record, Row 3. Compliance_code = "Performance" The region should still be displayed. On changing the 2nd Row (2. Compliance_code = "ESCALATION") value to some other value The region should be hidden.
Hi Vinish, We have created interactive grid and now we want to display Child report as Nested Report if i click on ID then child report will be display. So that I have used Plug in "Pretius APEX Nested Reports" . I have created it first with my Workspace account and working fine but when I implement it in our customer application then it's not working fine . workspace Details: DEMO_RESTFULL firstname.lastname@example.org Testonly Can you please prepared one demo how to add Nested Report in Interactive Grid Thanks Manoj