At 08:43 AM 5/12/2003 +0700, you wrote:

>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

This is a language question, not PHP. If you want to execute your
procedure, remove the SUSPEND; statement inside it.

Helen