OraFAQ Forum: SQL & PL/SQL » how can i insert .pdf into oracle database

Home » SQL & PL/SQL » SQL & PL/SQL » how can i insert .pdf into oracle database (oracle 10.2.0.4 )

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

how can i insert .pdf into oracle database [message #579171]

Fri, 08 March 2013 05:36

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579172 is a reply to message #579171]

Fri, 08 March 2013 05:42

Littlefoot
Messages: 16997
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).

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579173 is a reply to message #579171]

Fri, 08 March 2013 05:42

Michel Cadot
Messages: 54239
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579174 is a reply to message #579173]

Fri, 08 March 2013 05:51

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579175 is a reply to message #579174]

Fri, 08 March 2013 05:59

Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You MUST be kidding, right?

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579176 is a reply to message #579174]

Fri, 08 March 2013 05:59

Michel Cadot
Messages: 54239
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579177 is a reply to message #579176]

Fri, 08 March 2013 06:16

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579178 is a reply to message #579177]

Fri, 08 March 2013 06:33

Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know what to say ... ./fa/3314/0/

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579179 is a reply to message #579178]

Fri, 08 March 2013 06:45

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' )

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579180 is a reply to message #579179]

Fri, 08 March 2013 06:47

cookiemonster
Messages: 9169
Registered: September 2008
Location: Rainy Manchester

Senior Member

You realize that's what Littlefoot's link says?

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579272 is a reply to message #579179]

Mon, 11 March 2013 00:44

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579274 is a reply to message #579272]

Mon, 11 March 2013 01:26

Michel Cadot
Messages: 54239
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579275 is a reply to message #579274]

Mon, 11 March 2013 01:38

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579277 is a reply to message #579275]

Mon, 11 March 2013 01:45

Michel Cadot
Messages: 54239
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579280 is a reply to message #579277]

Mon, 11 March 2013 01:55

x-oracle
Messages: 298
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.

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579281 is a reply to message #579280]

Mon, 11 March 2013 02:07

Michel Cadot
Messages: 54239
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579283 is a reply to message #579281]

Mon, 11 March 2013 02:12

x-oracle
Messages: 298
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.

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579286 is a reply to message #579283]

Mon, 11 March 2013 02:31

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579288 is a reply to message #579286]

Mon, 11 March 2013 02:36

Michel Cadot
Messages: 54239
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So, what is the question?

Regards
Michel

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579291 is a reply to message #579288]

Mon, 11 March 2013 02:37

x-oracle
Messages: 298
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

Michel Cadot
Messages: 54239
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

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579300 is a reply to message #579298]

Mon, 11 March 2013 02:51

Michel Cadot
Messages: 54239
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you unable to execute CREATE DIRECTORY statement?

Regards
Michel

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579303 is a reply to message #579300]

Mon, 11 March 2013 03:00

x-oracle
Messages: 298
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

Report message to a moderator

Re: how can i insert .pdf into oracle database [message #579305 is a reply to message #579303]

Mon, 11 March 2013 03:04

Michel Cadot
Messages: 54239
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, it is possible.

Regards
Michel

Report message to a moderator

Previous Topic:	Many information with one row
Next Topic:	Calculate difference between multiple numbers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 02:50:21 CDT 2013

Total time taken to generate the page: 0.07812 seconds