Re: Oracle ver 7.0 install

In article <hkk.6.000EE471_at_ctt.bellcore.com>, hkk_at_ctt.bellcore.com (Hari Krishnan) writes:
|>
|> Hi!
|> I have been trying to compile a PL/SQL block at my installation. I
|> get a message 'Package DBMS_STANDARD must be created before using PL/SQL
|> block' . Since it has been installed new, I tried executing the script
|> CATPROC.SQL but it still gives the above message. Is there any other script
|> which needs to be executed ? The oracle is running on HP-unix. I don't have
|> access to the installation manuals but still I could not find anything in
|> the Administrator's guide.
|>
|> If any of you have any clue please do let me know. Thanks.
|>
|> Hari
|> ----------------------------------------------------------------------------
|>
|> Hari hkk_at_bae.bellcore.com _ _ _ _ _ _
|>
|> ----------------------------------------------------------------------------
|>

You do need to run catproc. Make sure that you run it as SYS, not system. That should create package standard. You also need PL/SQL to be installed - does the PL/SQL version appear when you connect with sqlplus? Received on Fri Sep 23 1994 - 19:16:36 CEST