Hello Jean-Michel,
That sentence in the documentation can be easily misunderstood, you are right.
You may want to use the two-argument STOP
STOP($RC, $ERRMSG);
here. The first argument is the number, the second (optional) argument is
the text.
Regards
Alexander Schr�der
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 04, 2004 9:45 AM
> To: MaxDb
> Subject: STOP in dbproc
>
>
>
> 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/[EMAIL PROTECTED]
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
