error catching problem

#1

Hi,

in every function/procedure i write i add this to catch errors:
EXCEPTION
WHEN OTHERS THEN
SET @err = cast(SQLSTATE as TEXT);
call log_err(@err,'function name');

It writes to log file SQLSTATE error. But all I have is number... for
example:
I know that 52003 is Column '%1' not found, but what can I do to catch
this column name? How to retrieve %1, %2 and so on?

Plz help

Adam

#2

On 19 Mai, 10:26, nemo <adam.samborow... (AT) gmail (DOT) com> wrote:

Quote:

Hi,

in every function/procedure i write i add this to catch errors:
* * EXCEPTION
* * * * WHEN OTHERS THEN
* * * * * * * * SET @err = cast(SQLSTATE as TEXT);
* * * * * * * * call log_err(@err,'function name');

look for the ERRORMSG() function

Regards
Thomas

#3

On 20 Maj, 12:54, tduemesnil <tduemes... (AT) googlemail (DOT) com> wrote:

Quote:

On 19 Mai, 10:26, nemo <adam.samborow... (AT) gmail (DOT) com> wrote:> Hi,

in every function/procedure i write i add this to catch errors:
* * EXCEPTION
* * * * WHEN OTHERS THEN
* * * * * * * * SET @err = cast(SQLSTATE as TEXT);
* * * * * * * * call log_err(@err,'function name');

* look for the *ERRORMSG() function

Regards
Thomas

Great, this is what I was looking for. Thanks

Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

error catching problem

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

error catching problem - 05-19-2010 , 03:26 AM

Re: error catching problem - 05-20-2010 , 05:54 AM

Re: error catching problem - 05-20-2010 , 09:34 AM