Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unanswered: pl/sql libraries

    i'd like to create a pl/sql library wich will be stored in my database, not in a file, i wrote the following cde in sql worksheet:
    CREATE OR REPLACE LIBRARY lib AS 'lib.pll' DATABASE;
    the following message apeare: library created with compilation errors.
    help me please ! thanks !

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: pl/sql libraries

    Originally posted by links
    i'd like to create a pl/sql library wich will be stored in my database, not in a file, i wrote the following cde in sql worksheet:
    CREATE OR REPLACE LIBRARY lib AS 'lib.pll' DATABASE;
    the following message apeare: library created with compilation errors.
    help me please ! thanks !
    try:

    SQL> SHOW ERROR LIBRARY lib

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    Unhappy

    thanks for answering so soon!
    i do what you tell me about, but the answer was: no error!
    but when i ask about the status of my library in user_objects ( select status from user_objects where object_name ='LIB' ) , the status is INVALID (not valid)!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •