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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
soterd procedure cursor infinite loop
yes..with millions of records...it keeps inserting the last record. The fetch from the second cursor returns that last record all the time and it never leaves that loop.- tsalinas
- Post #6
- Forum: Pervasive: Pervasive.SQL
-
soterd procedure cursor infinite loop
Aparently the exit condition is never met and the fetch keeps returning the last record.. IF SQLSTATE = '02000' THEN LEAVE INSLOOP2; END IF; is not working.- tsalinas
- Post #4
- Forum: Pervasive: Pervasive.SQL
-
soterd procedure cursor infinite loop
It getting stuck in the second loop in the insert statement, and it keeps inserting the same records over and over again. the table has about 7000 records- tsalinas
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
soterd procedure cursor infinite loop
I'm using Pervasive Database v8.7 and I have the following stored procedure that It doesn't work and goes into a endless loop. Is it that this database doesn't support nested cursors? thank you. CREATE PROCEDURE populate_test() AS BEGIN DECLARE :v_parent CHAR(20); DECLARE :v_part1 CHAR(20)...- tsalinas
- Thread
- Replies: 5
- Forum: Pervasive: Pervasive.SQL
