Home » Developer & Programmer » Reports & Discoverer » please give me the suggession what is the this internal Error
please give me the suggession what is the this internal Error [message #258329] Sat, 11 August 2007 01:07 Go to next message
aditya_gangadharam
Messages: 43
Registered: February 2005
Location: Hyderabad
Member

hi all,

I am calling an procedure in other database using the dblink called cms and after giving all the parameters the following code gives me an error 'ORA-01041 : Internal error. hostdef extention doesn't exist.

code is :


function AfterPForm return boolean is
p_errcd number:=0;
p_errmsg varchar2(100):=NULL;
begin
Cm_Sp_Monthly_Cont_Proc_Pdf@cms(:p_calyear,:p_calmonth,'SYSTEM',p_errcd,p_errmsg);
return (TRUE);
end;



regards,
aditya.
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
Littlefoot
Messages: 20888
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.
Previous Topic: parameter report
Next Topic: dragging of fields according to my choice in report
Goto Forum:
  


Current Time: Sat Dec 03 04:00:30 CST 2016

Total time taken to generate the page: 0.05869 seconds