Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX_UTIL.GET_PRINT_DOCUMENT in sql developer return Null

arlex valencia menaJul 30 2019 — edited Jul 30 2019

APEX_UTIL.GET_PRINT_DOCUMENT in sql developer return Null esta es la funcion que ejecuto desde developer y me devuelve nullo, pero si la ejecuto desde apex si funciona, favor su ayuda

This is the function that I run from developer and it returns null, but if I run it from apex if it works, please help

RETURN BLOB

AS

    l_document BLOB;

BEGIN

wwv_flow_api.set_security_group_id(my ws id);

l_document := APEX_UTIL.GET_PRINT_DOCUMENT (

    p_application_id     =>   444,

    p_report_query_name  => 'query_name',

    p_report_layout_name => 'layout_name',

    p_report_layout_type => 'RTF_FILE',

    p_document_format    =>  'pdf',

    p_print_server       =>  'url_print_server');

RETURN l_document;

END;

This post has been answered by InoL on Jul 30 2019
Jump to Answer
Comments
Post Details
Added on Jul 30 2019
1 comment
196 views