SQL Developer


Spool from SQL Developer 2.1


Hi all, i have various scripts that use spool to write results to text files. When i run these scripts i get errors for commands like "spool" and "prompt". It's possible to run this scripts and generate spools from my SQL Developer 2.1? Thanks in advance. 
Well, looking at the help center in 2.1, it shows spool IS and IS NOT supported. Prompt is supposed to be supported and I know it was in 1.54 as I use it in one of my scripts. What does the error message say?
Evita
Edited by: Evita on Jan 6, 2010 10:43 AM 
We've found that scripting in SQL*PLUS is easier for us. Of course, we've been using it for years and years ...
Evita pointed out that SQL*Developer's scriptiing capabilities are more limited than SQL*PLUS'. You can simulate spooling by executing the query(queries) as a script in the SQL worksheet and then saving the output pane.
Athough the prompt command probably won't work in SQL*DEVELOPER you can still use substitution variables, instead getting a default window with the name of your substitution variable allowing data entry. 
Hi, and thanks for your reply. The error message says:
Error starting at line XX in command
prompt ****
Error report:
Unknown Command 
Hi riedelme, and thanks for your reply. You'r right, i can copy the results in the messages-log window and paste in a text file, but i need to minimize the time to get all information and this solution also require that the original scripts to be modified deleting "prompt" commands and others. But, i think this is the better solution for now. Thanks. to you and for Evita too. 
Just FYI - I took my script that has about 1/2 dozen PROMPT commands and it did work in 2.1. The one command I keep forgetting to take out is SET LINESIZE. That SQL Developer doesn't care for but will run the script nonetheless
Evita 
jerazo wrote:
i can copy the results in the messages-log window and paste in a text file, but i need to minimize the time to get all information and this solution also require that the original scripts to be modified deleting "prompt" commands and othersYou can also save the contents of the results pane without cutting and pasting
1. Run the SQL as Script
2. Look at output in the script output pane and use the save (floppy disk) icon to save the contents of the pane 
Hi all, thanks for your responses. I've updated to sqldev 2.1 and like Evita says all works fine, and like riedelme says saving the file it's possible to get expected results. Best regards!

Related Links

Wrong column being updated
Exporting data with insert statements (with foreign key relationships)
Problem Recognizing syntax in Update Join Query
64bit 2008 R2 keeps asking for Java path
2.1.0.62: Bug editing text columns in multiple rows using editor-window
Wrapping Packages
how to migrate only packages
Data Flow Diagram - Associating Entity or Table with Information Store
2.1 EA1 Various Problems - Case Change/Auto Complete - line paste - & :
2.1 EA1 Export results
How to Change SQL Developer Password!!!
disable auto-capitalization in code editor?
Move selection up/down
SQL Developer and Cur_Type
query executing very slow
MySQL Offline Capture

Categories

ORACLE DEV
Fusion Middleware
WebCenter
XML
Java Server Pages (JSP)
Replication
Text
Supply Chain Managemen...
OO4O and Wizards [ARCH...
Industries Archived Fo...
Oracle Database Archiv...
Content Services
SyncML
Business Moderator Arc...
Migration
JSP (Korean)
EJB (Korean)
ODBC (Korean)
System Management and ...
Business Intelligence ...
Marketing
Hyperion System 9 BI+ ...
General CRM
Identity Management Ar...
Test Management/Functi...
Data Service Integrator
weblogic.developer.int...
WebLogic Integration N...
Pages
Construction and Engin...
EJB Development (Chinese)
BEA WebLogic Server (C...
Oracle WebLogic Commun...
Beehive Online
Designer (Korean)
ORDS, SODA & JSON in t...
Enterprise JavaBeans
Collections: Lists, Se...
Monitoring, Management...
Application Development
Abstract Window Toolki...
Java Plug-In
Installation and Integ...
Java Community Process...
AVK Portability
Java TV
Systems Maintenance
Oracle Net (SQL*Net、Ne...
JavaFX 2.0 and Later
R Technologies
Primavera Unifier User...
システム管理
Multitenant
Oracle Tuxedo (Japanese)
Daily Notifications
Architecture - General...
Oracle Messaging Cloud...
Houston TX Eloqua Users
Eloqua Share & Learn
Eloqua Experience 2013
Canadian B2B Marketers
Oracle Marketing Cloud...
Grupo Eloquea – Latino...
Interact 2014 Presenta...
Eloqua - BlueKai Integ...
Costa Rica
IT Strategies from Oracle
Oracle Business Intell...
Global Trade Management
Discussion - Accenture...
20 Days of Java in Brazil
Peru
Bare Metal Cloud Servi...
From MOOC1
Ecuador
Find PLM Apps
Java Development Tools
Application Server
SQL and PL/SQL
Archived Forums
LCM: Managing Oracle A...
Sensor-Based Services ...
Administration
Automated Regression T...
General
weblogic.aqualogic.dat...
liquid.developer.inter...
Web Application Develo...
J2ME Development (Chin...
Swing
Developer Studio C/C++...
Storage General Discus...
RTSJ (Real-Time Specif...
Big Data Connectors/Ha...

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App