Home » SQL & PL/SQL » SQL & PL/SQL » How to load image in Long Raw column (Oracle 9i, Windows XP)
icon3.gif  How to load image in Long Raw column [message #407853] Thu, 11 June 2009 23:58 Go to next message
amit_yadav
Messages: 11
Registered: January 2009
Location: India
Junior Member
Dear all,

I need to upload a jpg image to a Long Raw column in one of our tables. Is there a way or utility so that I can do this thru a PL/SQL code? Please help.

Regards,
Amit
Re: How to load image in Long Raw column [message #407854 is a reply to message #407853] Fri, 12 June 2009 00:07 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>I need to upload a jpg image to a Long Raw column in one of our tables.

Both 9i & LONG are obsoleted.
You need to join the 21st century.

>Is there a way or utility so that I can do this thru a PL/SQL code?

Are both GOOGLE & SEARCH broken for you?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

[Updated on: Fri, 12 June 2009 00:07]

Report message to a moderator

Re: How to load image in Long Raw column [message #407881 is a reply to message #407853] Fri, 12 June 2009 03:11 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Use a BLOB, not a LONG RAW
Previous Topic: Table partitioning
Next Topic: Issue in "connect by level" (merged 3)
Goto Forum:
  


Current Time: Sat Dec 03 20:05:07 CST 2016

Total time taken to generate the page: 0.03666 seconds