PL/SQL? HTP Library linking?
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 departmentReceived on Thu Dec 11 1997 - 00:00:00 CET