sql command not propery ended in the spool file output
Posted on 2008-10-11
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