Home » Developer & Programmer » Forms » Hide URL call over web_show_document (Oracle 12C)
Hide URL call over web_show_document [message #687700] Fri, 12 May 2023 11:51
crodrigo
Messages: 1
Registered: May 2014
Location: Colombo
Junior Member
Call URL over PLSQL, by passing the following details

  PK_COMMON.pu_set_url ( 'RC',
                           :PARAMETER.FC_FUNCTION_ID,
                           :PARAMETER.FC_JOB_NUMBER,
                           :PARAMETER.FC_SESSION,
                           wkUrlP,
                           wkUrlE);

have received the following URL:

"<IP and Port> /CrystalInfoIns/ExcelReport?ABLE_NAME='XYZ'&JOB_ID=23050000012969&QUERY_COLUMN=JOB_NUMBER&REPORT_NAME=Outstanding&MOD ULE=RC&USER=scott "

This is calling as follows, it is working fine:                             
 WEB.SHOW_DOCUMENT(wkUrlE,'_blank');

But due to heavy data have experienced performance issues. During that time period, the user can copy the URL and it is run independently.

Hence we need to block coping or hide the URL from the end user.

---------------------------------------------------------------

I have tried as follows, but a blank chrom browser page displayed.

    --WEB.SHOW_DOCUMENT('javascript:void(window.open("' || wkUrlE || '"))', '_blank');
    
    --WEB.SHOW_DOCUMENT ('javascript:void(window.open(wkUrlE,_blank))','_blank');
    
    --WEB.SHOW_DOCUMENT('javascript:void(window.open(wkUrlE, "_blank"))', '_blank');


Kindly advise me on this to find the solution.

Thanks,
Chandana

Previous Topic: Ctrl+V
Next Topic: table right user
Goto Forum:
  


Current Time: Thu Mar 28 11:06:47 CDT 2024