Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    40

    Unanswered: How to compile plsql files?

    Hi,


    How can a set of plsql files stored in a .txt file can be executed in command line?.


    Thanks,
    Kamesh.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    What kind of command line?

    SQL Plus command line:
    Code:
    SQL> @file.txt
    OS command line:
    Code:
    > sqlplus username/password@db @file.txt

  3. #3
    Join Date
    Jul 2004
    Posts
    40
    Hi Adrew,

    Thanks for your prompt reply!!!!.

    But, there is a problem. I executed @file.txt and the following error was thrown

    SP2-0734: Unknown command beginning "<filename>" - rest of line ignored.

    file.txt contains a set of files. For eg.,

    car.sql
    steering.sql
    chassis.sql
    engine.sql

    are the files. When executed above said error was thrown.

    Please help on this.

    Thanks,
    Kamesh.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Amend file.txt so that it reads:

    @@car.sql
    @@steering.sql
    @@chassis.sql
    @@engine.sql

    because "@@" means "run the following script from same folder as file.txt"

Posting Permissions

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