src/odbc/unittests/raiserror

Main

Hostnameobon110
gcc versiongcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)
uname -aLinux obon110 2.6.26.2-1smp #1 SMP Tue Aug 19 10:16:15 CEST 2008 i686 i686 i386 GNU/Linux
date2008-11-21

odbctest
--------

connection parameters:
server:   'TESTSRV'
user:     'test'
password: '????'
database: 'test'
use test
CREATE PROCEDURE #tmp1
    @InParam int,
    @OutParam int OUTPUT,
    @OutString varchar(20) OUTPUT
AS
     SET @OutParam = @InParam
     SET @OutString = 'This is bogus!'
     SELECT 'Here is the first row' AS FirstResult
     RAISERROR('An error occurred.', @InParam, 1)
     SELECT 'Here is the last row' AS LastResult
     RETURN (0)
RAISERROR('An error occurred.', 5, 1)
Result=0 DIAG REC 1: State=01000 Error=50000: [FreeTDS][SQL Server]An error occurred.
Result=0 DIAG REC 1: State=01000 Error=50000: [FreeTDS][SQL Server]An error occurred.
SpDateTest Output:
   Result = 0
   Return Code = -12345
   OutString = "Te"
raiserror.c:214 Invalid ReturnCode
SQL error 24000 -- [FreeTDS][SQL Server]Invalid cursor state

Main