Hi All,
Found the problem (for anyone interested!)
I have two ORACLE_HOMEs on my PC.... perl was built against 8.1 and I have
a 9.2.0.5 environment setup!
Thanks Martin and Ron for you help,
Regards
Tony
Hi Martin (& Ron),
I should never have doubted you.... must be the pressure/heat/old age :-)
Yes my db *is* dumping a trace file (it helps if you look at the right db
!)
But I'm still stuck.
>From sql:
SQL> select * from [EMAIL PROTECTED];
GLOBAL_NAME
--------------------------------------------------------------------------------
CSC_T.WORLD
from DBI... the top of the trace file:
*** SESSION ID:(13.393) 2004-07-29 17:55:06.995
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x1
0, PC: kpoddl()+80
*** 2004-07-29 17:55:07.890
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kpoddl()+80] [SIGSEGV]
[Address not
mapped to object] [16] [] []
Current SQL statement for this session:
select * from [EMAIL PROTECTED]
----- Call Stack Trace -----
.
anyone got any pointers?
TIA
Tony
<polite cough>
Hi, I'm new to this group and Perl/DBI in general, but I hope I will be
able to help.
I think Ron has a good point, Tony. 3113 is basically an error that
means the communication channel was closed down by the server. There
should be some indication on your servers in log or trace files as to
what went wrong. Even if your service croaked really quickly I would
expect a core or something.
The error may be provoked by DBI, but it's happening on your server.
Martin
[EMAIL PROTECTED] wrote:
>
>
>
>Hi Ron,
>
>Thanks for the feedback, but the queries are only:
>
> select * from [EMAIL PROTECTED]
>and
> select object_name FROM [EMAIL PROTECTED] WHERE
>object_type ='SYNONYM'
>
>which obviously work from sqlplus, so that's why I suspect the
>DBI/DBD-Oracle. There are no alert logs errors, even when perl/DBI croaks
>on the query.
>
>Regards
>Tony
>
>
>
>
