Search results
14 wrz 2009 · We now have to create a pdf file. I was planning on using pdfsharp/migradoc to do it, but then we'd have to create document and time its readiness with sql server data state and mail state. It'd be nice if the db could handle everything.
7 maj 2013 · How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
2 cze 2021 · Using the new SQL scalar function GENERATE_PDF to create PDF in the IFS from spool files
28 lip 2017 · Let's start with a header of procedure or function we are documenting. Standard Header. There is not really something like a standard header, there are a few templates but they really boil down to basically the same. Let's have a look at SQL Server Management Studio standard header:
11 kwi 2012 · declare t_rc sys_refcursor; t_query varchar2(1000); begin as_pdf3.init; as_pdf3.load_ttf_font( 'MY_FONTS', '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 ...
20 paź 2010 · begin as_pdf_mini.init; as_pdf_mini.set_format(‘A4′,’L’); select c2 into v_blob from test where c1=’a’; if v_blob is null  then as_pdf_mini.write(‘NULLLLLL’, 10,10); else as_pdf_mini.write(‘Not Null’, 10,10); as_pdf_mini.put_image(v_blob, 10,100,400,300); end if; as_pdf_mini.save_pdf (null,’a.pdf’); end;
Rather than pulling the data out to a client sqlplus session on an ETL server, converting to PDF, then loading it back into the database as a BLOB, we do so directly in PL/SQL. We also gain page format, margins, and font control, plus optional grid lines/cells for the column data values.
