| Inconsistant DataType error with Cursor. [message #60322] |
Mon, 02 February 2004 05:09 |
Vinny75
Messages: 44
Registered: October 2003
|
Member |
|
|
Folks,
This stumped me big time. I have a simple cursor that makes references to tables residing on different database via DBLink.
Select A,B,C
from ( select A,B,C
from dblink1.tab1 tab1
where tab1.d = 100)
where rownum < 1001
If I change 1001 to a variable of number type, I get inconsistant data type error. Makes no sense. Also if I remove the database link and refer to a local table, rownum comparison to a number variable works. What is a link got to do with datatype issue when using rownum?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
