declare
t_rc sys_refcursor;
t_query varchar2(1000);
begin
as_pdf3.init;
as_pdf3.load_ttf_font( 'MY_DIR', 'COLONNA.TTF', 'CID' );
as_pdf3.set_page_proc( q'~
begin
as_pdf3.set_font( 'helvetica', 8 );
as_pdf3.put_txt( 10, 15, 'Page #PAGE_NR# of "PAGE_COUNT#' );
as_pdf3.set_font( 'helvetica', 12 );
as_pdf3.put_txt( 350, 15, 'This is a footer text' );
as_pdf3.set_font( 'helvetica', 'B', 15 );
as_pdf3.put_txt( 200, 780, 'This is a header text' );
as_pdf3.put_image( 'MY_DIR', 'amis.jpg', 500, 15 );
end;~' );
as_pdf3.set_page_proc( q'~
begin
as_pdf3.set_font( 'Colonna MT', 'N', 50 );
end;~' );
t_query := 'SELECT * FROM MY_USER.TEST2';
open t_rc for t_query;
as_pdf3.refcursor2table( t_rc );
as_pdf3.save_pdf;
end;

begin
as_pdf3.init;

as_pdf3.set_page_proc( q'~
begin
as_pdf3.put_image( 'MY_DIR', 'amis.jpg', 1000, 770 );
as_pdf3.set_font( 'helvetica', 8 );
as_pdf3.set_font( 'helvetica', 12 );
as_pdf3.put_txt( 350, 15, 'This is a footer text' );
as_pdf3.set_font( 'helvetica', 'B', 15 );
as_pdf3.put_txt( 200, 780, 'This is a header text' );

end;~' );


as_pdf3.set_font( 'times', 'I' );
  
as_pdf3.query2table( 'SELECT * FROM MY_USER.TABLE', p_headers =>  as_pdf3.tp_headers( 'COLUMN1' ,  'COLUMN2' ));

as_pdf3.save_pdf;

end;