Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    15

    Red face Unanswered: Sql script works in SQL Developer not SQLPlus under UNIX

    I have written a sql program under the SQL Developer tool. The script runs fine. However, I need to run it under UNIX, SQL Plus. When I attempt to execute it from SQL Plus (@programname.sql) it echos the last line number previous to the ending 'Exception' code and goes out into never, never land.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It can be a REAL challenge to debug code that can not be seen.

    It would have been VERY helpful if you had shared actual problem code with us.

    Try this shot in the dark solution
    add a new line to the end of your code where is contains a single slash character "/"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Terminator I

    Add a semicolon ( ; ) at the end of each sql statement or a slash (/) after the statement and try again...

    .
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Aug 2010
    Posts
    15

    Talking

    Thanks for the suggestion! Putting the '/' works. I guess it is not necessary in SQL Developer, it will run without it but SQL Plus wants it. I will remember that!! Thanks again

Posting Permissions

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