Re: Command file and input truncation and some other things

Eric Lilja wrote:
Hello, I have written this command file:
$ cat create_manager_table.sql
-- TODO: Check if manager table exists already and, if so, prompt
-- user to run the the drop_manager_table.sql script first.

--DBMS_OUTPUT.PUTLINE('Test');

ALTER TABLE employee
DROP CONSTRAINT fk_emp_mgr;

ALTER TABLE dept
DROP CONSTRAINT fk_dept_employee;

CREATE TABLE manager
(key INTEGER NOT NULL,
bonus INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY(key),
FOREIGN KEY(key) REFERENCES employee(key)
);


INSERT INTO manager(key)
((SELECT DISTINCT manager
FROM employee
WHERE manager IS NOT NULL)
UNION
(SELECT DISTINCT manager
FROM dept));

-- Note: These ALTER TABLE statements must be performed
-- *AFTER* we've filled the manager table with data! This
-- is because the employee/dept tables already contain
-- data and the manager table does not.
ALTER TABLE employee
ADD CONSTRAINT fk_employee_manager
FOREIGN KEY(manager)
REFERENCES manager(key);

ALTER TABLE dept
ADD CONSTRAINT fk_dept_manager
FOREIGN KEY(manager)
REFERENCES manager(key);

UPDATE manager
SET bonus=(bonus + 10000)
WHERE key IN (
SELECT manager FROM dept
);

When I run it, the following output is generated:
SQL> @ create_manager_table.sql





Table altered.








Table altered.








Table created.








12 rows created.








Table altered.








Table altered.





Input truncated to 5 characters





11 rows updated.





SQL>

What exactly is Oracle complaining about regarding the message about
input truncation and how do I fix it? And any ideas how I should
implement the comment at the top the command file (check if a table
already exists before proceeding). And how do I print out arbitrary
text in the command file?

/ E

It is complaining about the lack of a blank line at the end of the
script: Ignore it.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.

Relevant Pages