Executing Scripts

If you run generated scripts using either SQL*Plus or SQL Worksheet and you prompt users for input, this command before the generated SQL:

set define off

You can either execute this new line separately before you execute the generated SQL or you can generate the new line along with the generated SQL.