Table already exists - SQLERRCODE -310
This is a multi-part message in MIME format. ------=_NextPart_000_002C_01C07C7A.BC74CF00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I am invoking a stored procedure from a Powerbuilder front-end program. = The stored procedure creates a temporary table during processing. = Frequently (not at all times), upon running the program an error is = reported stating that the table temporary already exists.=20 Could someone please explain to me why this happens.=20 Thanks for your help. Dayton. ------=_NextPart_000_002C_01C07C7A.BC74CF00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>Hi All,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>I am invoking a stored procedure = from a=20 Powerbuilder front-end program. The stored procedure creates a temporary = table=20 during processing. Frequently (not at all times), upon running the = program an=20 error is reported stating that the table temporary already exists. = </FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>Could someone please explain to me = why this=20 happens. </FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>Thanks for your help.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>Dayton.</FONT></DIV></BODY></HTML> ------=_NextPart_000_002C_01C07C7A.BC74CF00--