PL/SQL? HTP Library linking?

From: Darin P. Stahl <LNUSCSI.DSTAHL01_at_eds.com>
Date: 1997/12/11
Message-ID: <348FFE1A.6C56_at_eds.com>#1/1


Hello all,

This may be covered in a FAQ, it may be beat to death in this newsgroup in the past, but, I haven't seen it yet... Hopefully someone can shed some light or let me know where to look for help...

I have a UNIX server, the Oracle admin here is trying to load ORacle Web Server and the PL/SQL libraries. They've done it in the past (with the help of other admins, now unavailable) on another UNIX server.

Anyway, I think something is either missing in the install, or there are other problems. Oracle 7.3.3, and OWS 3.0 (?). Oracle is installed fine on the box. I can access sqlplus, no problem. Tables are all created, data loaded to the tables, check...

When I try to compile procedures that have pl/sql calls (HTP.PRINT, etc), I get the following:

SQL> _at_Get_Org

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE GET_ORG:

LINE/COL ERROR



37/4     PLS-00201: identifier 'HTP.PRINT' must be declared
37/4     PL/SQL: Statement ignored

My oracle admin is stumped. He says the install went corectly, he really doesn't know what to do next. Oracle is not very forthcoming in their tech support on this issue. Any help would be greatly appreciated.

Thanks,

Darin.

-- 
Darin Stahl                            "If you read this sig
EDS ??? (DtE has me in flux right now)  You're mind will surely enlarge
http://www.eaglequest.com/~lonestar     or maybe it won't"   **

** Brought to you by the stupid Haiku department
Received on Thu Dec 11 1997 - 00:00:00 CET

Original text of this message