| ora-01002 error [message #115972] |
Fri, 15 April 2005 11:22  |
skccc
Messages: 3
Registered: April 2005
|
Junior Member |
|
|
I've encounter a quite special error in Oracle Form 6.0 and oracle 8i... the case is:
(1) i have a quite long string for query, with 'select from ....' but not insert/delete/update
(2) i need to use DBMS_SQL dynamic cursor to get my desired result
(3) after DBMS_SQL.execute(sumcursor) is run, i get every row by Looping througt the resultset if fetch(sumcursor) > 0;
but now, Ora-01002 occurs when fetching the resultset....it is said from the docs that it may occur when fetching over the last set of cursor, but the fact is that All Above runs Completely smoothly until i changed something in the query string. What's the reason behind? Any solutions to overcome or get around? Coz it sounds so weird.... Thanks!!
|
|
|
|
| ora-01002 error (more info) [message #116038 is a reply to message #115972] |
Sat, 16 April 2005 11:43  |
skccc
Messages: 3
Registered: April 2005
|
Junior Member |
|
|
Here is the whole scenario... hope it makes clearer for my problem
The full code is as below..
(*) there are 0 rows returned from the cursor
(*) i've changed a little bit in the query_str
(parse a query_str into DBMS_SQL)
(DBMS_SQL.define_column.... etc stuff)
DBMS_SQL.execute(sumcursor); -- Still ok in here
LOOP
-- system halts in here
IF (DBMS_SQL.fetch(sumcursor) > 0) THEN
(do something)
ELSE
EXIT;
END IF;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
