JasperReports Server with Oracle APEX (9) :call jasper report from Oracle APEX( English Subtitle )

JasperReports Server with Oracle APEX (9) : call jasper report from Oracle APEX
-------
My New Course on udemy

----
my blogger

[unsshahid]

Its Done.
Thanks Alot,
You are great.
Jazakallah.

[akaaka-uggs]

السام عليكم و جزاك الله خيرا
شرحك أكثر من إحترافي.
عندي سؤال:
هل يمكن عمل نفس الطريقة مع ORACLE REPORTS SERVER(WEBLOGIC)
بوركت

[unsshahid]

I have school registration table and one table is student registration, school registration for heading and student registration for detail. how to add multiple table in jasper

[unsshahid]

Dear will we use two oracle table data in jasper report?

[mahmoudtaha]

بيظهر error دة بعد ما بينزل pdf لما افتح الملف HTTP Status 505 – HTTP Version Not Supported

[unsshahid]

Dear when i run this error is showing ORA-20987: The requested URL has been prohibited. Contact your administrator.

[alisaleh]

DECLARE

  v_blob                 BLOB;

  v_file_type            VARCHAR2 (25) := 'pdf';

  v_file_name            VARCHAR2 (25) := 'TEST_P.'||v_file_type;

  v_vcContentDisposition VARCHAR2 (25)  := 'inline';

  v_DEPTNO NUMBER := :P3_DEPTNO;

  v_hostname   VARCHAR2(30) := 'localhost';

  v_port       NUMBER       := '6060';

  v_username   VARCHAR2(50) := 'jasperadmin';

  v_password   VARCHAR2(50) := 'jasperadmin';

  v_jasper_string VARCHAR2(30) := v_username || ';' || v_password;

  v_login_url  VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest/login';

  v_report_url VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || || v_file_name;

BEGIN

  -- log into jasper server

  v_blob :=

    p_url => v_login_url,

    p_http_method => 'GET',

    p_parm_name => apex_util.string_to_table('j_username;j_password', ';'),

    p_parm_value => apex_util.string_to_table(v_jasper_string, ';')

  );

  -- download file

    v_blob :=

    p_url => v_report_url,

    p_http_method => 'GET',

    p_parm_name => apex_util.string_to_table('P_DEPTNO', ';'),

    p_parm_value => apex_util.string_to_table(v_DEPTNO, ';')

  );

  --OWA_UTIL.mime_header ('application/pdf', FALSE);  -- view your pdf file

  OWA_UTIL.MIME_HEADER( 'application/octet', FALSE ); -- download your pdf file

  HTP.p('Content-Length: ' || DBMS_LOB.GETLENGTH(v_blob));

  HTP.p('Content-Disposition: ' || v_vcContentDisposition ||'; filename="' || v_file_name || '"');

  OWA_UTIL.http_header_close;

 

 



END;

[unsshahid]

RA-20987: The requested URL has been prohibited. Contact your administrator. after pressing print button.