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

Using DBMS_LOB.SUBSTR(TO_LOB(...

Status
Not open for further replies.
sem

sem

Programmer
Jun 3, 2000
4,709
UA
Hi,
I need to write pure sql query to extract a part of long column. I'm trying to use TO_LOB in conjunction with DBMS_LOB.SUBSTR, but get ORA-00932: inconsistent datatypes error. Does anybody have a clue or at least explanation of this behavior?

Regards, Dima
 
Status
Not open for further replies.

Similar threads

Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
351
Olutee360
Olutee360
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
2K
EM1107
EM1107
ClowneUser
  • Locked
  • Question
Using sysdate as a paramter
Replies
1
Views
286
Beilstwh
Beilstwh
rk68
  • Locked
  • Question
data import using SQLLDR
Replies
5
Views
263
rk68
rk68
rk68
  • Locked
  • Question
Using dbms_connection_pool
Replies
0
Views
158
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top