Re: [Sqlrelay-discussion] bad pl/sql kill sqlrelay connexion

[David M. <dav...@fi...>]

Looks like a bug.  I'll see if I can reproduce this and get a fix out.

Dave
dav...@fi...

On Tue, 2007-09-18 at 17:03 +0200, Huve Loic wrote:
> 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
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion