Home » Developer & Programmer » Forms » how to store image in sql plus??
how to store image in sql plus?? [message #633572] Sun, 22 February 2015 02:56 Go to next message
saraa
Messages: 14
Registered: February 2015
Junior Member
i want to save image in sqlplus. and then i want to display that image at oracle form 10g, from database.
Re: how to store image in sql plus?? [message #633573 is a reply to message #633572] Sun, 22 February 2015 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use DBMS_LOB.LOADFROMFILE procedure.

[Updated on: Sun, 22 February 2015 03:56]

Report message to a moderator

Re: how to store image in sql plus?? [message #633574 is a reply to message #633573] Sun, 22 February 2015 04:16 Go to previous messageGo to next message
saraa
Messages: 14
Registered: February 2015
Junior Member
please write in detail. i saved image in sqlpus through Toad. now how to display that at form.
Re: how to store image in sql plus?? [message #633575 is a reply to message #633574] Sun, 22 February 2015 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What you say is meaningless, if you did it in SQL*Plus you did not do it in TOAD and vice versa.
Your last postdoes not match your first one:
1/ i want to save image in sqlplus
2/ i saved image in sqlpus through Toad

Please first think what is your question.

Re: how to store image in sql plus?? [message #633576 is a reply to message #633575] Sun, 22 February 2015 04:25 Go to previous messageGo to next message
saraa
Messages: 14
Registered: February 2015
Junior Member
u never used toad? toad also saved data in sqlplus.
Re: how to store image in sql plus?? [message #633577 is a reply to message #633576] Sun, 22 February 2015 04:27 Go to previous messageGo to next message
saraa
Messages: 14
Registered: February 2015
Junior Member
it is easy to use toad rather to query in sqlplus. so im jst sayng i saved the image in Db nw how to display that image in forms. ??
Re: how to store image in sql plus?? [message #633578 is a reply to message #633577] Sun, 22 February 2015 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think TOAD is just b...
Anyway, what is the question, in the end?

Re: how to store image in sql plus?? [message #633579 is a reply to message #633578] Sun, 22 February 2015 04:32 Go to previous messageGo to next message
saraa
Messages: 14
Registered: February 2015
Junior Member
i saved the image in database. now i want to retrieve that image on form 10 g.
Re: how to store image in sql plus?? [message #633580 is a reply to message #633579] Sun, 22 February 2015 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't know but I know this question has been posted many times so you should find the solution just searching.

Re: how to store image in sql plus?? [message #633581 is a reply to message #633580] Sun, 22 February 2015 04:39 Go to previous messageGo to next message
saraa
Messages: 14
Registered: February 2015
Junior Member
i am doing it. thankyou
Re: how to store image in sql plus?? [message #633611 is a reply to message #633576] Mon, 23 February 2015 03:15 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
abira wrote on Sun, 22 February 2015 10:25
u never used toad? toad also saved data in sqlplus.


You seem to have sqlplus confused with the database.
Sqlplus is a program used to interact with the database, same as toad. It makes no sense to say you used toad to save data in sqlplus. It's like saying you used word to save data in notepad.
Re: how to store image in sql plus?? [message #659728 is a reply to message #633611] Sat, 28 January 2017 07:57 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
https://oracle-base.com/articles/misc/html-with-embedded-images-from-plsql
Re: how to store image in sql plus?? [message #659737 is a reply to message #659728] Sat, 28 January 2017 10:45 Go to previous message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What does storing image from a web site site has to do with this question which is about Forms?
And by the way it is 2 years old.

Previous Topic: Form 6i custom login system with source code
Next Topic: FRM-40102 record must be entered or deleted first
Goto Forum:
  


Current Time: Tue May 26 22:58:27 CDT 2020