1 Reply Latest reply: Oct 23, 2012 12:12 PM by hh*394375*91 RSS

    Having problems trying to run a sql script using the command prompt.

    hh*394375*91
      I place my script at the root c:
      open run SQL Command Line.
      I connected to the database using connet userid/password
      Then I tried to execute the script by doing

      @test_add_comments

      I am getting the error message.

      SQL> @test_add_comments
      SP2-0310: unable to open file "test_add_comments.sql"


      Am I suppose to place this sql somewhere else?


      test_add_comments.sql is

      COMMENT ON COLUMN myTable.ID IS 'Primary Key' ;
      COMMENT ON COLUMN myTable.REVIEWLOG_ID IS 'REFERENCE TO SAFE REVIEW LOG TABLE' ;
      COMMENT ON COLUMN myTable.FAC_ID IS 'REFERENCE TO ALL FACILITIES' ;
      COMMENT ON COLUMN myTable.HALLBUILD_ID IS 'REFERENCE TO HALL BUILDING' ;