SLES9/x86-64, Oracle 9.2.0.4/AMD64 ORA-07445 when function pipe 2004-12-10 - By Dmitry Melekhov
Hello!
I know that this this combination is not certified yet.
But may be somebody had such problem.
We run following function
CREATE OR REPLACE FUNCTION "ZVN"."OTPUSK" (find_fam IN varchar2, find_tab_n
IN VARCHAR2)
(find_fam IN VARCHAR2, find_tab_n IN VARCHAR2)
RETURN nejav_tab PIPELINED
IS
BEGIN
FOR c IN (SELECT c.f_name AS im, c.m_name AS ot, c.l_name AS fam,
e.tab_n AS tab_n, l.d_from AS dn, l.d_to AS dk,
'??????' AS tip
FROM hr_prod.pr_emp e, hr_prod.pr_card c,
hr_prod.pr_leave l
WHERE e.card_id = c.ID
AND e.ID = l.emp_id
AND ( NOT find_fam IS NULL
AND (LOWER (c.l_name) LIKE LOWER (find_fam))
OR NOT find_tab_n IS NULL AND e.tab_n = find_tab_n
)
ORDER BY l.d_from DESC)
LOOP
PIPE ROW (nejav_row (c.fam, c.im, c.ot, c.tab_n, c.dn, c.dk, c.tip));
END LOOP;
RETURN;
END;
and we get following error:
Fri Dec 10 21:12:17 2004
Errors in file /home/oracle/OraHome1/admin/BOSS/udump/boss_ora_10299.trc:
ORA-07445 (See ORA-07445.ora-code.com): exception encountered: core dump [pfrtcs()+75] [SIGSEGV] [Address
not mapped to object] [0x00000007C] [] []
ORA-07445 (See ORA-07445.ora-code.com): exception encountered: core dump [pbt_flags()+18] [SIGSEGV]
[Address not mapped to object] [0x0000000C0] [] []
This error appears with some parameters, but it is 100% reproducable .
And this is first time we try to use function pipes, but other functions
work... :-)
Any ideas?
May be there is already patch to fix this?
Unfortunately, we run developer's version of Oracle... I have access to
metalink, but we currently have license only for Oracle x86
(we are going to buy licenses for this server in January), so I don't shure
I can create TAR...
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
