No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 18-OCT-07
Type Comment
User Geert De Paep
Message Regading the error:
224/5 PLS-00201: identifier 'HTP.PRN' must be declared
224/5 PL/SQL: Statement ignored

You are probably using oracle 8.1.6, or you have a database where the Oracle OWA toolkit is not installed.

You can solve this by installing the owa toolkit or creating a dummy htp package with only one procedure:

create package htp
is
procedure prn(Msg in varchar2);
end;
/
create package body htp
is
procedure prn(Msg in varchar2)
is
begin
null;
end;
end;
/