• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 782
  • Last Modified:

SQL Plus hangs

I am creating stored procs using SQL Plus  by copying and pasting the code. It works great with most sprocs. If sproc is more then 135-150 lines long, SQL Plus stops responding and I have to restart it. Sproc is not created. What's the problem and how can I get around it? OS is WinXP. I'd like to run 'show err' after that to see compilation errors.
0
quasar_ee
Asked:
quasar_ee
1 Solution
 
oratimCommented:

Just create SQL file using any editor, such as notepad,  then run it from the SQL prompt

SQL> @C:\files\SQL\Scripts\Procedures.sql

If you do that, make sure there are no spaces in the path, or enclose the entire path in quotes.


0
 
seazodiacCommented:
did you put a '/' at the end?
0
 
oratimCommented:
Yes, put the / at the end of the file
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
paquicubaCommented:
A maximum of 3625 characters can be pasted in SQL*Plus Interface


That's what I prefere to use the command-line interface.
1. Go to your sql*plus icon, right click and select properties
2. Remove the w from C:\oracle\ora92\bin\sqlplusw.exe  to make it like C:\oracle\ora92\bin\sqlplus.exe
3. You can also add C:\oracle\ora92\bin\sqlplus.exe username/password@databasename @commands . To log you in and set parameters. You need to load the commands file in the same path your sqlplus.exe is or if it's in your local machine, you need to specify the path ( for example: @c:/commands.txt ).
4. You can then make the command-line look like sql*plus interface right clicking in the icon an make changes to the layout, options and colors.
5. Make sure in the options tab ( under Edit Options)  you select QuickEdit mode, so you can paste to the command-line with one right click and copy from it selecting the area to be copied and pressing the enter key.

Hope this helps.
0
 
pradeep257Commented:
The best thing is to save the SQL code in a script file and execute it from the command line or from SQL PLUS. It will be easy for you to do any changed, if required in the file itself and execute in again.

 As oratim as mentioned use the following command to execute the script file in the SQL PLUS.

@ filname.sql

Give the full path after the @ symbol.
0
 
quasar_eeAuthor Commented:
>>Just create SQL file using any editor, such as notepad,  then run it from the SQL prompt
It works. Thank you.
>>A maximum of 3625 characters can be pasted in SQL*Plus Interface
Looks I can't paste more than 140 characters. Any idea how to increase this number?
0
 
seazodiacCommented:
your comments --->Looks I can't paste more than 140 characters. Any idea how to increase this number?


I think this has nothing to do with SQLPLUS environment. it's a DOS windows property.

can you try this:

in DOS windows, click the top left corner of the dos window, go to properties----->click options tab,

in this window, increase buffer size and number of buffers in command history

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now