SQL Plus stops before finishing

15 pts.
Tags:
SQL Plus
SQL statements
Why does SQL+ stop after running so many characters in a long SQL statement?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Some clarification is needed to be able to help you. What exactly do you mean by "stops" ?  Does it stop working, or just stops showing results?  do you see an error message?  Also, is it a long SQL statment or a query that returns a big number of rows? or a query that takes to long to give results?
    70,220 pointsBadges:
    report
  • rayfish2013
    I think I am having a similar problem.  When asked by carlosdl as to whether it was a long SQL statement or a query that returns a big number of rows, I'm not exactly sure myself, as the SQL was sent to me to run.  From what I can see, it has multiple similar INSERT commands.  When I paste the SQL text at the SQL> prompt in SQL+, it will run approx 9 or 10 of these commands, which in total consists of 2,767 characters (I pasted into Excel to get a count).  It runs the SQL until it gets to that point, then it stops, or pauses, but with no errors.  If I copy and paste some more of the SQL, the remainder that immediately follows the point where it stopped, it will continue from that point and run some more of the SQL, but it will again "stop" at another point, again with no errors, it just sits there.  It doesn't appear that there is anything wrong with the SQL file itself, because the people who sent it to me test it on there end to verify it will run successfully, then they send it to me to run on our copy of the database to correct some issues we are having.  Sorry for the lack of knowledge on my part, but if someone can help, I'll try to give more info if needed.
    15 pointsBadges:
    report
  • carlosdl
    I understand. Don't copy the SQL text into SQL*Plus. Instead, put the text into a text file in your hard disk, and execute it from SQL*Plus this way: SQL>@C:\path\to\your\file.sql
    70,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following