Hello,
I have downloaded postgresql 7.2 on my machine.
Running ecpg on my .ec-file I found that ecpg did not process
the statements "exec sql declare xxx cursor for select.
The part in my .ec-file:
if ( firstcall )
{
calid1 = calid;
EXEC SQL DECLARE CURMFDPOINT CURSOR FOR SELECT STABLE_OR_INSTABLE ,
HIERARCHY , POINT_ID , X1 , P1 , X2 , P2 FROM MANIFOLD_POINTS WHERE
CAL_ID = :calid1;
raiseerror( );
firstcall = false;
}
was transformed into
if ( firstcall )
{
calid1 = calid;
/* declare CURMFDPOINT cursor for select STABLE_OR_INSTABLE , HIERARCHY , POINT_ID , X1 , P1 , X2 , P2
fromMANIFOLD_POINTS where CAL_ID = ? */
#line 224 "dbcontrol.ec"
raiseerror( );
firstcall = false;
}
So the declare cursor statement was just commented out. As a consequence the
programm terminated with sqlca.sqlcode=-602 when doing the according
fetch statement.
best regards
Bernhard Rueckerl
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
