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!

dbms_lob.compare giving ora-06502 during long raw type column compare

Status
Not open for further replies.
beksalur

beksalur

Technical User
Jan 2, 2003
74
TR
hi,
i write a procedure which check if the table long raw columns is same for two schemas' same tables with dmbs_lob.compare function.But at row 1771 i am getting ora-06502 :pL/SQL numeric or value error string error.

i wonder why it occurs?

Regards.
 
Status
Not open for further replies.

Similar threads

Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
461
Rasheed Shaik
Rasheed Shaik
mibeach7
  • Locked
  • Question
OEM extract ORA- from string text 1
Replies
2
Views
115
mibeach7
mibeach7
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
395
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
812
carp
carp

Part and Inventory Search

Sponsor

Back
Top