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!

  • Congratulations Mike Lewis 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

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.

Part and Inventory Search

Sponsor

Back
Top