[python-sybase] (no subject)

Pavel Pavel <achilles at pisem.net>
Thu, 12 Feb 2004 13:50:50 +0500


Hello

Please look at the following:

>>> import Sybase
>>> db = Sybase.connect('sybase_server', '*', '*', 'xcvb')
>>> c = db.cursor()
>>> c.execute('ERROR_STATEMENT')
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 687, in execute
    self.description = fetcher.start(self.arraysize)
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 442, in start
    return self._start_results()
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 546, in _start_results
    status, result = self._cmd.ct_results()
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 161, in _servermsg_cb
    raise DatabaseError(_fmt_server(msg))
Sybase.DatabaseError: Msg 2812, Level 16, State 5, Line 1
Stored procedure 'ERROR_STATEMENT' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

>>> c.close()
>>> db.rollback()
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 889, in rollback
    self.execute('rollback transaction')
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 906, in execute
    fetcher.start(self.arraysize)
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 260, in start
    status = self._cmd.ct_send()
  File "/usr/local/python/lib/python2.3/site-packages/Sybase.py", line 157, in _clientmsg_cb
    raise DatabaseError(_fmt_client(msg))
Sybase.DatabaseError: Layer: 1, Origin: 1
ct_send(): user api layer: external error: This routine cannot be called because another command structure has results pending.
>>>


what am I doing wrong?