ecpg did not precompile declare cursor
От | Bernhard Rückerl |
---|---|
Тема | ecpg did not precompile declare cursor |
Дата | |
Msg-id | 02021822430200.00596@asterix обсуждение исходный текст |
Ответы |
ecpg did not precompile declare cursor
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: