Error while executing SP

Posted in 1999

george — Tue, 7 Sep 1999 20:07:45 +0530 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. ------=_NextPart_000_0135_01BEF96C.A62EC620 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I'm trying to execute a SP through ESQL/C. This SP returns 0 if no error = has occured, else the error number is returned. the code is something like this: EXEC SQL PREPARE procerr from "EXECUTE PROCEDURE LDC_SP_UPDDELMNT()"; EXEC SQL EXECUTE procerr INTO :interrno; if (interrno !=3D 0) { rgetlmsg(interrno, strerrmsg, sizeof(strerrmsg), &intmsglen); printf("\\n Error encountered in procedure \\n"); printf("\\n Error %d: \\n", interrno); printf(strerrmsg); exit(1); } The SP executes fine when I run it throughdbaccess and SQL editor for = Win NT. But when I run my program,I get the following error: Error encountered in procedure Error 82620: Unknown error message 82620.=20 And Informix crashes down. The online.log gives the following message: 20:00:22 Assert Failed: Internal Error - Segmentation Violation 20:00:22 Who: Session(5, georgem@jupiter, 29749, 170714280) Thread(57, sqlexec, a2ad530, 1) 20:00:22 Results: OnLine must abort 20:00:22 Action: Reinitialize shared memory 20:00:22 See Also: /tmp/af.39b526, shmem.39b526.0 20:00:28 rsinit.c, line 9495, thread 57, proc id 29672, Segmentation = Violation. 20:00:29 PANIC: Attempting to bring system down =20 My SysAdmin is going crazy over this. Well, so am I. What could be wrong? INFORMIX-SQL Version 7.20.UC2 =20 Thanks, George ------=_NextPart_000_0135_01BEF96C.A62EC620 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>I'm trying to execute a SP through = ESQL/C. This SP=20 returns 0 if no error has occured, else the error number is=20 returned.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>the code is something like = this:</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>EXEC SQL PREPARE procerr from "EXECUTE = PROCEDURE=20 LDC_SP_UPDDELMNT()";<BR> EXEC SQL EXECUTE procerr INTO=20 :interrno;<BR> if (interrno !=3D=20 0)<BR>  {<BR>  rgetlmsg(interrno, strerrmsg,=20 sizeof(strerrmsg), &intmsglen);<BR>  printf("\\n Error = encountered=20 in procedure \\n");<BR>  printf("\\n Error %d: \\n",=20 interrno);<BR>  printf(strerrmsg);<BR>  exit(1);<BR>&= nbsp; }</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>The SP executes fine when I run it = throughdbaccess=20 and SQL editor for Win NT. But when I run my program,I get the following = error:</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Error encountered in = procedure</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2> Error 82620:<BR>Unknown error = message 82620.=20 </FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>And Informix crashes down. The = online.log gives the=20 following message:</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>20:00:22  Assert Failed: Internal = Error -=20 Segmentation Violation<BR>20:00:22   Who: Session(5, = georgem@jupiter,=20 29749,=20 170714280)<BR>         &nbsp= ;     =20 Thread(57, sqlexec, a2ad530, 1)<BR>20:00:22   Results: OnLine = must=20 abort<BR>20:00:22   Action: Reinitialize shared=20 memory<BR>20:00:22   See Also: /tmp/af.39b526,=20 shmem.39b526.0<BR>20:00:28  rsinit.c, line 9495, thread 57, proc id = 29672,=20 Segmentation Violation.<BR>20:00:29    PANIC: Attempting = to bring=20 system down         = </FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>My SysAdmin is going crazy over this. = Well, so am=20 I.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>What could be wrong?</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>INFORMIX-SQL Version=20 7.20.UC2     </FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>George</FONT></DIV></BODY></HTML> ------=_NextPart_000_0135_01BEF96C.A62EC620--

Error while executing SP

Related threads

Your privacy choices