I declare a cursor as below: DECLARE links_cur SCROLL CURSOR IS SELECT * FROM road; and get this error: CONTEXT: invalid type name "SCROLL CURSOR IS SELECT * FROM road" If I take away 'SCROLL', it has no problem. Any hint? Thanks, cyw
I declare a cursor as below: DECLARE links_cur SCROLL CURSOR IS SELECT * FROM road; and get this error: CONTEXT: invalid type name "SCROLL CURSOR IS SELECT * FROM road" If I take away 'SCROLL', it has no problem. Any hint? Thanks, cyw