Solved

sql command not propery ended in the spool file output

Posted on 2008-10-11
2
488 Views
Last Modified: 2013-12-18
Hi
I am using spool to run the statement
select ' grant SELECT, INSERT, UPDATE, DELETE ' || ' on DBSEC.'|| table_name || ' to DBSEC_SUPERVISOR_ROLE ' || ';'    
from dba_tables where owner = 'DBSEC' ;

but the output spool file not generating the statements in one line (limiting to 80 characters along with spaces). I am getting the error since the statement is braking into two. give me the solution please
0
Comment
Question by:ravalireddy
2 Comments
 
LVL 42

Accepted Solution

by:
dqmq earned 250 total points
ID: 22694506
set linesize 1000
0
 
LVL 32

Assisted Solution

by:awking00
awking00 earned 250 total points
ID: 22694741
Rather than creating a spool file, then executing it, why not do as attached?
run-grants.txt
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question