What is checksum in oracle apex and How to create Checksum?
Most of the Students Have been Asking me the Answer for What Is Checksum In Oracle Apex . So we are here very happy to Help you by providing the Answers.
First of all you would like to enable Deep Linking (go to the appliance Properties > Security > Session Management and set Deep Linking to Enabled). you’ll learn more about deep linking within the documentation.
Also, you’ve got to enable Session State Protection for the item that you simply want to line in URL (in my case P2_DEPTNO):
Before generating URL you’ve got to make session:
begin apex_session.create_session (105,1,’MGORICKI’);
end;/
As I said in my previous blog post, to use any of the procedures from the apex_session package you’ve got to run them as application parsing schema, one among schemas assigned to the workspace or one among the users with APEX_ADMINISTRATOR_ROLE role.
After that you ought to be ready to create URL with the checksum by calling apex_page.get_url function:
- MGORICKI@db12c.local> begin
- 2. dbms_output.put_line(
- apex_page.get_url (
- p_application => 105,
- p_page => 2,
- p_items => ‘P2_DEPTNO’,
- p_values => ’10’)
- );
- end;
- /
MGORICKI @db12c.local > exec apex_session.create_session (105,1,’MGORICKI’);
PL/SQL procedure successfully completed.
- MGORICKI@db12c.local> begin
- dbms_output.put_line(
- apex_page.get_url (
- p_application => 105,
- p_page => 2,
- p_items => ‘P2_DEPTNO’,
- p_values => ’10’)
- );
- end;
- /