OraFAQ Forum: Forms » Hide URL call over web_show

Home » Developer & Programmer » Forms » Hide URL call over web_show_document (Oracle 12C)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 07:41:08 CST 2025