tag:blogger.com,1999:blog-5215551487816981140.post285401862617083155..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Free PDF package for PL/SQLMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-5215551487816981140.post-67019136316319935192013-10-22T05:03:05.584-07:002013-10-22T05:03:05.584-07:00hello morten I have a problem in pl_fpdf, how do i...hello morten I have a problem in pl_fpdf, how do i render unicode character in pdf. I've tried addfont function and included .ttf file in fonts directory but It didn't worked. Please reply and thanks in advanceBikesh Maharjannoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-57265965352730313182013-02-13T20:24:37.655-08:002013-02-13T20:24:37.655-08:00Hello Morten,
I am trying to add a chart in pd...Hello Morten,<br /><br /> I am trying to add a chart in pdf, and that chart has to be generated from the data inside database, but can't find any procedure for that. Please let me know what should I do for that.<br /><br />Regards<br />TauceefOracle Apex Solutionshttps://www.blogger.com/profile/09842867581298935178noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-91529448683093383212013-02-12T07:07:39.343-08:002013-02-12T07:07:39.343-08:00can you please how can I get the file location ?
i...can you please how can I get the file location ?<br />i.e., where and how a pdf file can be created ?<br />and how to change its destination folder ?<br />reply awaited...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-82744852539856941822012-03-18T08:59:06.050-07:002012-03-18T08:59:06.050-07:00Hello Morten,
I've looked into the Alexandria...Hello Morten,<br /><br />I've looked into the Alexandria plsql and it looks really good. I'm a little caught in the middle with not being an expert pl/sql programmer.<br /><br />The AS_PDF is fairly good but lacks functionality. However it has 1 or 2 things which are great. The handling of images and save pdf.<br /><br />How would one go about merging AS_PDF image functions into PL_FPDF. Is there a place where to make the request for the merge?<br /><br />The reason I ask, is because with Anycharts you now have a getPNG function with returns base64 incoding, but PL_FPDF doesn't support that type of image input, further more it requires a ORDImage, big minus when working on Express Editions.<br /><br />Thank<br /><br />JanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-68301113907810024432011-12-13T08:25:48.504-08:002011-12-13T08:25:48.504-08:00I used the package PL_FPDF To generate an out put ...I used the package PL_FPDF To generate an out put PDF from Apex 4.1 but I have this output.<br />Why(It work for me on Apex 4.2.3)<br /><br />thanks for responding<br /><br /><br />%PDF-1.3 3 0 obj <> endobj 4 0 obj <> stream 2 J 0.56 w BT /F1 12.0 Tf ET BT 31.18 781.59 Td (Une Page PDF vierge) Tj ET endstream endobj 1 0 obj <> endobj 5 0 obj <> endobj 2 0 obj << /ProcSet [/PDF /Text /ImageB /ImageC /ImageI] /Font << /F1 5 0 R >> /XObject << >> >> endobj 6 0 obj << /Producer (PL_FPDF 0.9.1 portage pour Laclasse.com par P.G. Levallois de la version 1.53 de PHP/FPDF d'Olivier Plathey.) /CreationDate (D:20111213102214) >> endobj 7 0 obj << /Type /Catalog /Pages 1 0 R /OpenAction [3 0 R /Fit] /PageLayout /SinglePage >> endobj xref 0 8 0000000000 65535 f 0000000211 00000 n 0000000400 00000 n 0000000009 00000 n 0000000087 00000 n 0000000304 00000 n 0000000504 00000 n 0000000679 00000 n trailer << /Size 8 /Root 7 0 R /Info 6 0 R >> startxref 777 %%EOFhakimhttps://www.blogger.com/profile/15620397620602551321noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-25108245411787706642011-09-20T10:05:05.568-07:002011-09-20T10:05:05.568-07:00@Pramod: The query in the test code references the...@Pramod: The query in the test code references the "dba_tablespaces" view. Either make sure you have access to this view, or change the query so it references some of your own tables/columns.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-20469592427249890952011-09-14T03:58:12.213-07:002011-09-14T03:58:12.213-07:00hi...
when i run test_pl_fpdf procedure(after crea...hi...<br />when i run test_pl_fpdf procedure(after creating pl_fpdf),<br />i've face following error:<br />-----------------------------------<br />22/15 PL/SQL: SQL Statement ignored<br />22/69 PL/SQL: ORA-00942: table or view does not exist<br />24/2 PL/SQL: Statement ignored<br />24/20 PLS-00364: loop index variable 'L_REC' use is invalid<br />25/2 PL/SQL: Statement ignored<br />25/20 PLS-00364: loop index variable 'L_REC' use is invalid<br />27/2 PL/SQL: Statement ignored<br />27/5 PLS-00364: loop index variable 'L_REC' use is invalid<br />32/2 PL/SQL: Statement ignored<br />32/20 PLS-00364: loop index variable 'L_REC' use is invalid<br /><br /><br />----------------<br />plz send the solution of it to my email id:<br />pramod14march@gmail.comPramod K Sharmahttps://www.blogger.com/profile/07282951753043667588noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-40459904584113997712011-05-22T10:14:22.383-07:002011-05-22T10:14:22.383-07:00Has anyone implemented any of the other scripts fr...Has anyone implemented any of the other scripts from fdf.org? Some of the scripts look great such as the multi-cell tables, html tables, etc… Since these are written in php, we would just need to convert these to plsql.<br /><br />Also because of the 32k limit the re-write to clobs is necessary.<br /><br />Perhaps we could collaborate on such a project.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-23796556828988853102011-03-05T05:26:09.051-08:002011-03-05T05:26:09.051-08:00Thanks for putting this together.
Can somebody pl...Thanks for putting this together.<br /><br />Can somebody please clarify how you managed to get around the 32K limit on varchar2s? I quickly hit that ceiling when trying to generate a report with a few thousand rows.<br /><br />To address a couple of the other questions asked in this thread:<br /><br />1. I think the idea is to execute this package using mod_plsql from a browser. If you say call helloworld it will open the PDF up in the browser.<br />2. A simple change to the Output procedure can instead write the pdf to a database table in a blob column. I did this by creating a new output procedure and then removed all reference to myDest. Then immediately after the loop for i in pdfDo... I did the following insert:<br /><br />/*<br />create table test_blob (col_blob blob,<br />creation_date date)<br />*/<br />insert into test_blob values (v_doc, sysdate);Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-87728742294195417022010-12-28T08:34:20.580-08:002010-12-28T08:34:20.580-08:00How do i run this run.?shall i just use execute bu...How do i run this run.?shall i just use execute button in toad?<br />where does the pdf gets stored?<br />what does this pl_fpdf.Output ();<br />mean? . is there any documentation for this. <br /><br />I am trying to learn FPDF. <br /><br />Thanks for a great post.<br />SKAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-9393717988115536202010-11-14T07:50:54.712-08:002010-11-14T07:50:54.712-08:00Hi. I have configured the parameter SetAutoPageBr...Hi. I have configured the parameter SetAutoPageBreak to true pl_fpdf.SetAutoPageBreak (true, 20);, and when the text of the second page begins with bold doesn't make until it find pl_fpdf.SetFont ('Times',' B ', 11);. How you can help me with this problem.AndyRNhttps://www.blogger.com/profile/04507430351090053670noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-27821336564497486252010-11-13T08:12:54.850-08:002010-11-13T08:12:54.850-08:00This comment has been removed by the author.AndyRNhttps://www.blogger.com/profile/04507430351090053670noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-80899561354449957842010-11-10T06:44:05.005-08:002010-11-10T06:44:05.005-08:00@Kishor: In Oracle 11g, there are network access c...@Kishor: In Oracle 11g, there are network access control lists (ACLs) on the network packages, such as UTL_HTTP. Perhaps that is why the image download fails? <br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-30324626054344614732010-11-10T06:42:38.829-08:002010-11-10T06:42:38.829-08:00@Hurol and @Anonymous: As written, the package run...@Hurol and @Anonymous: As written, the package runs into problems with the 32K limit on varchars in PL/SQL. I tried to contract the original package author about it, but never got any reply.<br /><br />In my own copy of the package, I fixed this by using clobs instead of varchars to build the output. <br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-13090695344401260312010-11-09T04:43:41.269-08:002010-11-09T04:43:41.269-08:00pl_fpdf is a great package.
We have been using it ...pl_fpdf is a great package.<br />We have been using it on oracle 10gr2, apex 3.1.<br />However, on Oracle11g, apex4.0, all works well except when image is included, the procedure hangs.<br />Has any one got any suggestions, ideas??Unknownhttps://www.blogger.com/profile/17762368354241464743noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-19041447971443214102010-10-26T07:26:18.138-07:002010-10-26T07:26:18.138-07:00I have the same problem
ORA-20100: PL_FPDF error:...I have the same problem<br /><br />ORA-20100: PL_FPDF error: Output : ORA-06502: PL/SQL: numeric or value error<br />ORA-06512: at "DEMO.PL_FPDF", line 1928<br />ORA-06512: at "DEMO.PL_FPDF", line 3264<br />ORA-06512: at "DEMO.TEST_PL_FPDF", line 100<br />ORA-06512: at line 2Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-81456569155331580932010-03-04T23:11:31.023-08:002010-03-04T23:11:31.023-08:00Hi,
I receive the following error when I try to r...Hi,<br /><br />I receive the following error when I try to run. I know it is about the package but can you provide me some help?<br /><br />ORA-20100: <b>PL_FPDF error: </b>Output : ORA-06502: PL/SQL: numeric or value error<br />ORA-06512: at "DEMO.PL_FPDF", line 1928<br />ORA-06512: at "DEMO.PL_FPDF", line 3264<br />ORA-06512: at "DEMO.TEST_PL_FPDF", line 100<br />ORA-06512: at line 2hurolhttps://www.blogger.com/profile/09773219741816190562noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-26217981182427657022010-01-25T14:30:35.818-08:002010-01-25T14:30:35.818-08:00Mark, do you mind sharing your codes that can save...Mark, do you mind sharing your codes that can save the pdf inside a blob field in your database?<br />Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-46415994178490189352009-12-14T06:59:47.789-08:002009-12-14T06:59:47.789-08:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/09846045758187428462noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-14364709825262326162009-10-21T06:25:43.195-07:002009-10-21T06:25:43.195-07:00Hi Morten, I've uploaded both files, but then ...Hi Morten, I've uploaded both files, but then when I tried to run the pks one, I got this error message.<br /> <br />ORA-06508: PL/SQL: could not find program unit being called<br /><br />ERR-1024 Unable perform processing<br /><br />btw I'm running oracle XE, should I comment out some procedures? if yes, would you mind to elaborate more about it.<br /><br /><br />thx<br /><br />guntherAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-64600799166428412312009-10-16T07:57:50.578-07:002009-10-16T07:57:50.578-07:00@ Gunther:
The "pks" file is the packag...@ Gunther:<br /><br />The "pks" file is the package specification, the "pkb" file is the package body.<br /><br />To install from Apex, go to the "SQL Workshop" tab, click "SQL Scripts", then "Upload" and upload the two files.<br /><br />The click to run the "pks" script first, and then the "pkb" script second.Morten Bratenhttps://www.blogger.com/profile/16506692325808919895noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-27226763310267854842009-10-16T07:47:22.032-07:002009-10-16T07:47:22.032-07:00hi, can you please tell me how to install the pack...hi, can you please tell me how to install the package?<br /><br />I've downloaded the zip file, it contains 2 files pkb, pks.<br /><br />the procedures, function are there. then should I just remake one by one.<br /><br />or apex got some import function or something like that??<br /><br />thanks <br /><br /><br />guntherAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-59199517338718657412009-10-12T03:00:00.792-07:002009-10-12T03:00:00.792-07:00@Anonymous: I have added a short step-by-step guid...@Anonymous: I have added a short step-by-step guide on how to use PL_FPDF from Apex, see <br /><br />http://ora-00001.blogspot.com/2009/10/how-to-integrate-plfpdf-with-apex.html<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/16506692325808919895noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-42195327970723548362009-10-10T08:06:13.446-07:002009-10-10T08:06:13.446-07:00And how would you integrate this in Apex? Being ju...And how would you integrate this in Apex? Being just a beginner, I'm clueless.... Could you maybe blog a step-by-step tutorial on this?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-20111725021689119112009-10-09T04:37:11.823-07:002009-10-09T04:37:11.823-07:00It's great post but I did not found some thing...It's great post but I did not found some things:<br />- encoding: can I use cp1250 example?<br />- compress: PDF is too big without compress <br />- TTF support<br />- Images: Intermedia is an Enterprise Edition option, it's not cheap product<br />Regards,<br />LLAnonymousnoreply@blogger.com