Subject problem
Author Hidayat Henokh
i have posted this problem but still no answer

i have a stored procedure that do some check before it do some update to
database, every time it found a condition that not meet with the
condition that required it raise an exception.

my problem is if i execute the stored procedure from my php script with
"select" method the exception value is not showed so the user cannot
know why the program is stopped and error, but if execute the stored
procedure with "execute" method when every thing goes well we still got
an error, here is the error :

execute procedure CLOSING_CHECK('AP','20030729')
cannot be executed!
Error : message length error (encountered 0, expected 4)

my sp is returned an integer variable

i apriciate every clue that you will give to me