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

[Jim]

On 6-6-2010 19:06, Jim wrote:
> On 6-6-2010 16:06, Michael Van Canneyt wrote:
>>
>>
>> On Sun, 6 Jun 2010, Jim wrote:
>>> (gdb) break fpc_raiseexception
>>> Breakpoint 1 at 0x40a9c6
>>> ...... debug output....
>>> Breakpoint 1, 0x0040a9c6 in fpc_raiseexception ()
>>> (gdb) backtrace
>>> #0  0x0040a9c6 in fpc_raiseexception ()
>>> #1  0x0043d284 in
>>> IBCONNECTION_TIBCONNECTION_$__CHECKERROR$ANSISTRING$PISC_STATUS ()
>>
>> OK, this means you've found an error in the error handling code of
>> TIBConnection. Unfortunately, there is not enough info to pinpoint the
>> exact
>> location.
>>
>> Do you think you can recompile the ibconnection unit with debug info ?
>> (copying to to your project's directory should do the trick)
>>
>> Michael.
> On win32, I get this using a ibconnection unit compiled with -g -gl:
> (gdb) backtrace
> #0  0x0040a9c6 in fpc_raiseexception ()
> #1  0x0043d29e in TIBCONNECTION__CHECKERROR (PROCNAME=0x483320 "Execute",
>     STATUS=0x388338, this=0x3a0568) at ibconnection.pp:156
> #2  0x0043ec3d in TIBCONNECTION__EXECUTE (CURSOR=0x388320,
>     ATRANSACTION=0x3cf5c28, APARAMS=0x3df0140, this=0x3a0568)
>     at ibconnection.pp:670
> #3  0x0043ac1a in SQLDB_TCUSTOMSQLQUERY_$__EXECUTE ()
> #4  0x0043b7d9 in SQLDB_TCUSTOMSQLQUERY_$__EXECSQL ()
> #5  0x00437e51 in TFLOCATEDB__SAVEDIRECTORYENTRY (INSERTFIELDS=
>       {COMPUTERNAME = 0x3196b0 "MARVIN", DATEACCESSED =
> 40080.684351851851, DATE
> ... and the rest of the parameters...
> #6  0x00432cd7 in TDIRECTORYENTRYLIST__SAVETODATABASE (this=0x3195e8)
>     at directoryentrylist.pp:236
> #7  0x0042f359 in TFILESEARCH__SAVETODATABASE (this=0x319588) at
> search.pp:245
> #8  0x00401e62 in TFLOCATE__DORUN (this=0x3383f8) at flocate.lpr:247
> #9  0x0042dd54 in CUSTAPP_TCUSTOMAPPLICATION_$__RUN ()
> #10 0x004025ec in main () at flocate.lpr:330
> 
> 
Oops, let me check, I might've traced the wrong database error. Let me
set up my fake Firebird custom exception again & get back to you...

-- 
Regards,

jb