Re: ORACLE 9.2 SQL core dump

pat.saunders_at_sis.securicor.co.uk (pat saunders) wrote in message news:<bc0e3bd8.0406040055.c588a83_at_posting.google.com>...
> Hi, I am using Oracle 9.2 on solaris 8.
> I have an application program , written in c, unix, SQL . This worked
> fine
> in Oracle 7.3.4, We are now porting it to Oracle 9.2,
> The application core dumps on a simple
> EXEC SQL SELECT * FROM <TABLE_NAME> where <field> = 'TEST';
> with an alignment error :
> =>[1] __align_cpy_1(0x78d428, 0x0, 0x2c, 0x4, 0x20, 0x78d428), at
> 0xfe6d06a0
> [2] sqlcopydfn(0xff25092c, 0x793178, 0x70c780, 0x0, 0x1,
> 0xffbeb900), at 0xfe918688
> [3] sqlrdf(0xff25092c, 0x793178, 0x70c780, 0x0, 0x1, 0x0), at
> 0xfe9188f4
> [4] sqlatm(0x0, 0xff1d8204, 0x0, 0xffbebd18, 0x0, 0x1), at
> 0xfe9194e4
> [5] sqlnst(0x5, 0x793178, 0xffbebd18, 0x1, 0xff1d8204, 0x0), at
> 0xfe90bef0
> [6] sqlcmex(0xa0000, 0x0, 0xffbebd18, 0x3c418, 0x3, 0xc3c), at
> 0xfe90090c
> [7] sqlcxt(0x0, 0x3c428, 0xffbebd18, 0x3c418, 0x400, 0x4d8), at
> 0xfe900cf4
> [8] ACD_setup_voice(0xffbebe0c, 0x2c649c, 0x3ffd4, 0xc, 0x3a7fc,
> 0x0), at 0x17678
>
> Has anyone experienced the above problem and know how to fix it.
> Ta
> Pat

What language/tool is the application written in? Did you recompile/link it? There have been many proc*C and OCI changes between versions 7.3 and 9.2 so recompilation is pretty much a necessity. With proc*C and OCI successful recompilation is likely to involve some code changes if for no other reasons the C compilers have become more strict and there have been numerous OCI routine changes.

HTH -- Mark D Powell -- Received on Fri Jun 04 2004 - 09:29:03 CDT