Home » SQL & PL/SQL » SQL & PL/SQL » how can i insert .pdf into oracle database (oracle 10.2.0.4 )
how can i insert .pdf into oracle database [message #579171] Fri, 08 March 2013 05:36 Go to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
hello how can i insert .pdf file into my oracle database

can you suggest me the insert statement how can i insert this pdf file into my oracle database using insert statement
Re: how can i insert .pdf into oracle database [message #579172 is a reply to message #579171] Fri, 08 March 2013 05:42 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
PDF file is a BLOB, so - have a look (and/or search for more info, now that you know keywords).
Re: how can i insert .pdf into oracle database [message #579173 is a reply to message #579171] Fri, 08 March 2013 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using a BLOB.
There are many examples in this forum, just search for them.

Regards
Michel
Re: how can i insert .pdf into oracle database [message #579174 is a reply to message #579173] Fri, 08 March 2013 05:51 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
yes but just i want to upload this pdf file into my database using only insert statement.not using oracle sql loader.on internet so many example using oracle sqlloader
Re: how can i insert .pdf into oracle database [message #579175 is a reply to message #579174] Fri, 08 March 2013 05:59 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You MUST be kidding, right?
Re: how can i insert .pdf into oracle database [message #579176 is a reply to message #579174] Fri, 08 March 2013 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And did you at least read the link that has been provided to you?
No, of course, you are too lazy.

Regards
Michel
Re: how can i insert .pdf into oracle database [message #579177 is a reply to message #579176] Fri, 08 March 2013 06:16 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
no i am not kidding i have so many pdf file and here we have to requirement to upload this pdf file into this oracle database.but here we have rac database so i not want to upload this pdf file using directory so i want to upload this file into my database using insert statement just can u give me one example of this insert statement if we can.is it possible to upload this .pdf into oracle database using insert statement
Re: how can i insert .pdf into oracle database [message #579178 is a reply to message #579177] Fri, 08 March 2013 06:33 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know what to say ... ./fa/3314/0/
Re: how can i insert .pdf into oracle database [message #579179 is a reply to message #579178] Fri, 08 March 2013 06:45 Go to previous messageGo to next message
hemant_khandare
Messages: 65
Registered: November 2011
Member
hi friend,


you can do this

step 1> create directory on server
2>create table with blob type coloumn
3> insert using bfilename( 'directory', 'filename' )
Re: how can i insert .pdf into oracle database [message #579180 is a reply to message #579179] Fri, 08 March 2013 06:47 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
You realize that's what Littlefoot's link says?
Re: how can i insert .pdf into oracle database [message #579272 is a reply to message #579179] Mon, 11 March 2013 00:44 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
Thanks for your reply all of here.

and hemant I have rac database so can you help me.yeah I know using directory we can upload by sqlloader .but I do not know how can I create directory on rac database server.so can you please guide me.thats the reason I asked here how can I upload pdf file into database using insert statement
Re: how can i insert .pdf into oracle database [message #579274 is a reply to message #579272] Mon, 11 March 2013 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No difference to create a (Oracle) directory in RAC or not RAC.
The rest is in the link Littlefoot already provided.

Regards
Michel
Re: how can i insert .pdf into oracle database [message #579275 is a reply to message #579274] Mon, 11 March 2013 01:38 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
thanks for you reply Michel

Michel can you please help me how can create directory on rac database;

on single database we create like that

SQL > create or replace directory test as 'E:\test';



but here we have rac database server its db-1 and db-2 and actual databasefile and all this are store on exter storage .so how can I create directory on rac .please help me. I am new in rac so just please hint me
Re: how can i insert .pdf into oracle database [message #579277 is a reply to message #579275] Mon, 11 March 2013 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 11 March 2013 07:26
No difference to create a (Oracle) directory in RAC or not RAC.
The rest is in the link Littlefoot already provided.

Regards
Michel

Re: how can i insert .pdf into oracle database [message #579280 is a reply to message #579277] Mon, 11 March 2013 01:55 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
but Michel we have two server db1 and db2 so on which server I have to create directory.
Re: how can i insert .pdf into oracle database [message #579281 is a reply to message #579280] Mon, 11 March 2013 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You create the directory in the database, from which instance you do it does not matter.

Regards
Michel
Re: how can i insert .pdf into oracle database [message #579283 is a reply to message #579281] Mon, 11 March 2013 02:12 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
means if I create one folder on my db2 server and then use this folder as directory so its ok Michel.michel sorry for that I am asking you so much but its rac database and I work on rac database as new user so.
Re: how can i insert .pdf into oracle database [message #579286 is a reply to message #579283] Mon, 11 March 2013 02:31 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
and michel i read on this link also

my scenario its same like this and my question also same regarding to directory

https://forums.oracle.com/forums/thread.jspa?threadID=1043503
Re: how can i insert .pdf into oracle database [message #579288 is a reply to message #579286] Mon, 11 March 2013 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, what is the question?

Regards
Michel
Re: how can i insert .pdf into oracle database [message #579291 is a reply to message #579288] Mon, 11 March 2013 02:37 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
michel question is so how can i create directory on this rac database sir.you told me you can create directory in rac database as we can create directory on single database server.here we have to node db1 and db2 and database are on shared location on external storage.so how to create it.

[Updated on: Mon, 11 March 2013 02:39]

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579293 is a reply to message #579291] Mon, 11 March 2013 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is explained here, this is explaiedn in the thread you posted, what is the problem?

Regards
Michel

[Updated on: Mon, 11 March 2013 02:39]

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579298 is a reply to message #579293] Mon, 11 March 2013 02:49 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
so michel how can i upload this pdf file into database.because i know how to upload pdf into database using sql loader but for that i want directory and in rac database its not possible to create directory .so can you suggest me any insert statement to upload this pdf into database
Re: how can i insert .pdf into oracle database [message #579300 is a reply to message #579298] Mon, 11 March 2013 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you unable to execute CREATE DIRECTORY statement?

Regards
Michel
Re: how can i insert .pdf into oracle database [message #579303 is a reply to message #579300] Mon, 11 March 2013 03:00 Go to previous messageGo to next message
x-oracle
Messages: 332
Registered: April 2011
Location: gujarat
Senior Member
Michel so if i create one folder on my db2 server and use this folder as directory on my db2 instance and then i place this pdf file into this directory so its possible
Re: how can i insert .pdf into oracle database [message #579305 is a reply to message #579303] Mon, 11 March 2013 03:04 Go to previous message
Michel Cadot
Messages: 58950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is possible.

Regards
Michel
Previous Topic: Many information with one row
Next Topic: Calculate difference between multiple numbers
Goto Forum:
  


Current Time: Mon Sep 01 08:46:18 CDT 2014

Total time taken to generate the page: 0.26945 seconds