Re: FETCH Troubles!

could you post the whole code, exactly ...?

Scott J. Little (slittle_at_rmc1.crocker.com) wrote:
> This is my first posting to this newsgroup, but I've got a weird problem.
> I've written a report in Pro*C using embedded SQL. I go through all the
> proper steps (just like I have a hundred times before):
 

> DECLARE myCurs CURSOR FOR
> SELECT blah, blah, blah...
> ...
> ORDER BY 1, 2, 3;
 
> error checking
 

> OPEN myCurs;
 

> error checking
 

> FETCH myCurs INTO
> :hostVar1 :indVar1,
> :hostVar2 :indVar2;
 

> Seems correct, yes?
 

> Well I keep getting the following error when I run it:
 

> ORA-01630: max # extents (101) reached in temp segment in tablespace TEMPORARY
 

> ERR-ERRSTMT: Error occurred on following statement:
> SELECT SIRASGN_CRN,SIRASGN_PIDM FROM SATURN.SIRASGN,SATURN.SSBSECT,SAT
> %SYSTEM-F-ABORT, abort
 

> There is no way. The select is only supposed to return *** 10 *** rows -
> that's all. In fact if I take the select statement and run the exact
> statement in SQL*Plus I get my results back in no time flat.
 

> I can't understand why there would be such a great discrepency between the two.
 

> Any help would be greatly appreciated.
 

> sjl
 

> --
> Scott J. Little
> slittle_at_rmc1.crocker.com | http://crocker.com/~slittle
> .....................................................................
> You and I, we reject these narrow attitudes
> We add to each other, like a coral reef - Neil Peart, Rush
> Building bridges on the ocean floor "Alien Shore"
> Reaching for the alien shore
> [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[']]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]

--
**************************************************************
*                          Saad Ahmad                        *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************