[Sqlrelay-discussion] bad pl/sql kill sqlrelay connexion
Brought to you by:
mused
|
From: Huve L. <l....@fo...> - 2007-09-18 15:08:56
|
Hello, We have a strange problem since we use oracle pl/sql and sqlrelay. That arrived when we debug proc or test new proc, sqlrelay connexions are kill and disappear so we must restart it. Do you think there is something to do to avoid this problem I give you the connexion log and the error I find. Thank's a lot Loic error : - getting command failed: client sent bad command or timed out connexion log : begin PCK_LEAD_INFO.P_GET_PRICE_ONLINE( :FUPID , :SITE_ID , :COUNTRY_CODE , :CURSEUR , :ERROR ); end; getting query succeeded getting input binds... :FUPID STRING 00020905 :SITE_ID INTEGER 1 :COUNTRY_CODE STRING fr done getting input binds getting output binds... :CURSEUR CURSOR found a free cursor: 1 :ERROR INTEGER done getting output binds getting send column info... don't send column info done getting send column info... processing query... preparing/executing... commit or rollback check... commit or rollback needed done with commit or rollback check processing query failed done processing query handling error... returning error... failed to handle query: error done returning error done handling error... getting command... done getting command getting a cursor... done getting a cursor fetch from bind cursor handling query... getting send column info... send column info done getting send column info... processing query... bind cursor... commit or rollback check... commit or rollback needed done with commit or rollback check processing query succeeded done processing query returning result set header... returning row counts... sending row counts... actual rows unknown affected rows: 0 done sending row counts done returning row counts column info will be sent returning column counts... done returning column counts sending column type format... id's done sending column type format returning column info... done returning column info returning output bind values 2 2 0:CURSOR: 1 1:INTEGER: 0 done returning output bind values done returning result set header handle query succeeded returning result set data... done returning result set data getting command... done getting command getting a cursor... done getting a cursor abort result set getting command... getting command failed: client sent bad command or timed out <========== and my connexion is kill. end session ending session... aborting all busy cursors... 1 |