|
Re: please give me the suggession what is the this internal Error [message #258337 is a reply to message #258329] |
Sat, 11 August 2007 03:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It is a bug:Oracle | ORA-01041: internal error. hostdef extension doesn't exist
Cause: Pointer to hstdef extension in hstdef is null.
Action: Report as a bug
|
However, before reporting it as a bug, you could try to use a SYNONYM. Something like this:SQL> -- create a function in a remote database
SQL> connect mike/lion
Connected.
SQL> create or replace function fun_today return date is
2 begin
3 return sysdate;
4 end;
5 /
Function created.
SQL> -- create a database link and a synonym
SQL> connect scott/tiger
Connected.
SQL> create database link dbl_ora10_r
2 connect to mike
3 identified by lion
4 using 'ora10g';
Database link created.
SQL> select 'x' from dual@dbl_ora10_r;
'
-
x
SQL> create synonym syn_fun_today for fun_today@dbl_ora10_r;
Synonym created.
SQL> select syn_fun_today from dual;
SYN_FUN_
--------
11.08.07
SQL>
Doing so, you'd use a SYNONYM in report trigger instead of the original procedure via database link:
CREATE SYNONYM syn_cm_sp_monthly_cont_proc_pdf FOR
cm_sp_monthly_cont_proc_pdf@cms; Report trigger:
function AfterPForm return boolean is
p_errcd number := 0;
p_errmsg varchar2(100) := NULL;
begin
syn_Cm_Sp_Monthly_Cont_Proc_Pdf(:p_calyear,
:p_calmonth,
'SYSTEM',
p_errcd,
p_errmsg);
return (TRUE);
end;
Perhaps it'll help.
|
|
|