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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Spikmeister
- Content: Threads
- Order by date
-
Dynamic Cursors vs Standard Cursors - speed issue
I have two procedures that do identical things, one uses a Standard cursor that it loops through: CURSOR Cursor_SP IS SELECT ID, CCT_ID FROM SP_2 WHERE Inserted_By = 'I'; BEGIN FOR List_SP IN Cursor_SP LOOP (Lots of data crunching with other tables) END LOOP; END; The...- Spikmeister
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
ORA-01555: snapshot too old - Problem with Rollback Segments?
I'm using Oracle 8i and doing a data load of almost 800000 records. I then need to update all these records after doing some complex searching on other tables. However I keep getting this error (normally only a couple of hundred records short as well!): ORA-01555: snapshot too old: rollback...- Spikmeister
- Thread
- Replies: 74
- Forum: Oracle: All versions
-
Using variables within Connect By...???
I'm trying to use a connect by within a dynamic cursor but I keep encountering the error: ORA-09999: Message 9999 not found; product=RDBMS; facility=ORA ORA-02063: preceding line from TEST.WORLD Here's the sql from my dynamic cursor: select hier_view.ho_id, hier_view.lo_id...- Spikmeister
- Thread
- Replies: 2
- Forum: Oracle: All versions
