[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    STOP in dbproc
From:       Jean-Michel OLTRA <jm.oltra () espinasse ! net>
Date:       2004-08-04 7:44:40
Message-ID: 20040804074440.GA18601 () espinasse
[Download RAW message or body]


    bonjour,



I tried something like that:

TRY
    BEGIN
        some stuff here
    END;
CATCH
    IF $RC <> 100 THEN STOP ($ERRMSG);

But got:

Error during execution
-->-25010
SQL error -8006 = Data types must be compatible (error position:
657[line: 27, col: 27])

line 27 col 27 is $ of $ERRMSG

But the manual says (the one I have):

The database procedure is interrupted immediately when the STOP function
is invoked. The value of the first parameter of the STOP function is the
return or error message that the application receives as the result of
the database procedure call. An error text can also be returned.

Is it possible to return a text message as first parameter of STOP() ?

Thanks,

-- 
jm


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]