Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Long Raw Datatype

Status
Not open for further replies.
dougalim

dougalim

Programmer
Mar 1, 2007
23
US
A third party vendor stores a text file in a long raw datatype field in the database.

In PL/SQL I can see the data in the Large Data Edior when I click on the box with ... after a running a simple 'select column from table' sql statement.

How can I retrieve the column into a varchar2 in a stored procedure to allow me to use char functions to manipulate the text?

 
Status
Not open for further replies.

Similar threads

Toe
  • Locked
  • Question
putting lob column into raw
Replies
1
Views
50
LKBrwnDBA
LKBrwnDBA
billo102
  • Locked
  • Question
"Select * from view" takes a very long time,on second attempt 1
Replies
2
Views
132
billo102
billo102
kjv1611
  • Locked
  • Question
CREATE.. SELECT FROM PLAN_TABLE - illegal LONG datatype
Replies
4
Views
99
kjv1611
kjv1611
raygg
  • Locked
  • Question
Number to Raw datatype conversion for DW 1
Replies
13
Views
177
SantaMufasa
SantaMufasa
ljsmith91
  • Locked
  • Question
Query a 4 byte RAW Data field and convert bit settings to a string val 1
Replies
3
Views
84
ljsmith91
ljsmith91

Part and Inventory Search

Sponsor

Back
Top