[fpc-pascal] Firebird stored procedure exceptions generate access violation

[Jim]

On 5-6-2010 10:47, Michael Van Canneyt wrote:
> On Sat, 5 Jun 2010, Jim wrote:
<snip>
>> Finally, the question:
>> What I really want is to get a Firebird SQLCODE error code or some other
>> details that allow me to figure out whether one of my custom exceptions
>> get called. Also, it seems something is wrong after the error; although
>> the objects still seem to exist, the database obviously won't insert
>> anymore.
>>
>> How do I get proper error codes and/or fix this code? (Of course,
>> suggestions on code improvement etc are also welcome)
> 
> It might be worth putting all parameters in a record definition and pass
> the
> record to your function. That makes the procedure declaration somewhat more
> manageable and understandable. (and definitely more efficent as well).
> 
> Then, there is an access violation in your code:
> Try to get a stack trace, we can then tell where the access violation
> occured, maybe it will tell us a little more.
> 
> Michael.

Ok, I'll have a go at doing that... I'll get back to the list.

-- 
Regards,

jb