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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored procedure to change datatype

Status
Not open for further replies.
prigro

prigro

IS-IT--Management
Jan 3, 2002
42
0
0
CA
I would like to use crystal reports to report off a LONG RAW column in Oracle which contains text. Crystal Reports handles this datatype as a BLOB, therefore not displaying the text. I believe that a stored procedure can be used to solve this problem, unfortunately I don't know anything about stored procedures.

more Info:
Oracle 9i
Crystal Reports 9
Table name: NOTATION
column name: NOTE
 
Status
Not open for further replies.

Similar threads

sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
139
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
139
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
172
carp
carp
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
65
TheLazyPig
TheLazyPig
TheLazyPig
  • Locked
  • Question
Separate 1 row value to multiple rows
Replies
4
Views
156
carp
carp

Part and Inventory Search

Sponsor

Back
Top