Home » SQL & PL/SQL » SQL & PL/SQL » PDF to Oracle table (Oracle db 11.2.0.2)
PDF to Oracle table [message #573664] Wed, 02 January 2013 03:21 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Dear friends,

I need to develop a solution which will read data from a PDF file and insert them to a oracle table. The PDF file is text pdf, which is a kind of form. I need to read specific data from particular field and insert it to oracle table. I am not sure how to approach this problem. IF anyone has worked on such problems please guide me on this.

If some one knows a ready made tool available to do this please let me know. Even if I will have to buy license I may consider buying it.

Thanks
Ridhi Sundar
Re: PDF to Oracle table [message #573693 is a reply to message #573664] Wed, 02 January 2013 06:27 Go to previous messageGo to next message
Flyby
Messages: 143
Registered: March 2011
Location: Belgium
Senior Member
Perhaps using java/.net and an api-library
Re: PDF to Oracle table [message #573903 is a reply to message #573693] Fri, 04 January 2013 02:06 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I not good in java or .net. I was looking for if oracle has any capability to read from PDF file. Can utl_file be used to read pdf file?
Re: PDF to Oracle table [message #573904 is a reply to message #573903] Fri, 04 January 2013 02:32 Go to previous message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it can read it as any binary file.
Now it depends on what you mean by "read" and what you actually want to do with this file.

Regards
Michel
Previous Topic: Need equivalent Decode for this Case
Next Topic: Update query using case when exists
Goto Forum:
  


Current Time: Wed Jul 23 19:48:26 CDT 2014

Total time taken to generate the page: 0.13292 seconds