Subject: Aleatory exception
From: Sabin Coanda
Date: 11/23/2007 11:23:15 AM
Hi there,
I have a custom function where I execute a dynamic statement. I trap the
exceptions, and sometimes I got the following error data:
SQLSTATE = 22P02, SQLERRM = invalid input syntax for integer:
"NULL::int4"
For instance I got this for the following statement string:
Please explain what could be the reason ?
TIA,
Sabin
Subject: Aleatory exception
From: Sabin Coanda
Date: 11/23/2007 11:26:51 AM
Sorry for the previous incomplete text. I add the followings:
For instance I got that exception for the following statement string:
'"my_function"( NULL, ''TEXT1'', NULL::int4, NULL::int4, 5413, '''',
TIMESTAMP WITH TIME ZONE ''2007-11-23 10:08:29.904+02'', 19255, 0 )'
What is wrong with this statement ?
Regards,
Sabin
|