Home » SQL & PL/SQL » SQL & PL/SQL » Extract long Raw columns to file (oracle 8i)
Extract long Raw columns to file [message #302348] Mon, 25 February 2008 05:28 Go to next message
punithakamalam
Messages: 1
Registered: February 2008
Junior Member

I have a long raw column in a table which is an old system( I am aware that oracle does not support long raw).

The long raw column contains large documents > 32 K also.

I need to write a stored procedure to convert each long raw column into seperate files
Re: Extract long Raw columns to file [message #302349 is a reply to message #302348] Mon, 25 February 2008 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do it in PL/SQL in your version.
You have to write a C, Java or other language program.

Regards
Michel
Re: Extract long Raw columns to file [message #302443 is a reply to message #302348] Mon, 25 February 2008 12:25 Go to previous messageGo to next message
coleing
Messages: 213
Registered: February 2008
Senior Member
alternatively, upgrade the "data" in a test database and convert to lob. then extract.
Re: Extract long Raw columns to file [message #302447 is a reply to message #302443] Mon, 25 February 2008 12:45 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is the same problem with BLOB.

Regards
Michel
Previous Topic: how can I make Mobile column ?
Next Topic: Combine fields in query
Goto Forum:
  


Current Time: Wed Dec 07 08:58:03 CST 2016

Total time taken to generate the page: 0.09108 seconds