Hi all,
(This question has been asked before, however, on older db/apex versions and times change every new version, so I thought I'd give it a shot, maybe there are solutions now that I'm not aware of)
The problem:
In order to avoid to have to change 4 systems, our ideal situation would be to be able to extract the page count from a blob column containing PDF files and store the page count. Depending on that further specific processing follows.
I've seen a few ways here to tackle this, the ‘ctx_doc.policy_filter-way’ looks promising.
( How to find number of pages of PDF file in BLOB column. - Oracle Forums )
( How to read/view a BLOB Column value(Word doc/PDF files content) without download in Oracle Apex Interactive\Classic Report? - Oracle Forums )
I also found this:
php - Get the number of pages in a PDF document - Stack Overflow
but I'm not a PHP-guy. But it sure seems possible to get the page count.
However, I don't see page count in the metadata. I'm no PDF expert, so I wonder:
-
Is it possible that the page count isn't always available in the PDF file?
-
Are there other ways to obtain the page count, using Oracle/APEX packages/pl/sql only?
-
Why doesn't adobe just provide the metadata in a simple way? (this is not a serious question)
Many thanks in advance for clues/pointers/tips!
We're on db 19c / apex 24.1
Regards,
Hoek