On Mon, Aug 11, 2008 at 7:39 PM, David Durham, Jr. <david.durham.jr@gmail.com> wrote:
I've got a statement like this:

CREATE SEQUENCE VENDORS_RESOURCE_SQ;

           CREATE OR REPLACE TRIGGER VENDORS_RESOURCE_TR
           BEFORE INSERT ON "VENDORS_RESOURCE"
           FOR EACH ROW
           WHEN (new."ID" IS NULL)
               BEGIN
                   SELECT VENDORS_RESOURCE_SQ.nextval
                   INTO :new."ID" FROM dual;
               END;
               /

Which runs fine in sqlplus, but Squirrel will prompt for an input  for
parameter ":new".  I tried disabling all plugins that I thought might
be causing this, but couldn't find that right one.  Now, I didn't
restart squirrel, just unchecked the plugins in the plugins dialog.
Anyone know how to fix this one?  I have a workaround, but I'm just
curious.

Unchecking the plugins in the the plugin summary will prevent them from loading
at startup.  You can unload them without restarting by selecting the plugin(s)
in the table and pressing the "Unload" button.  The plugin that is responsible for
prompting for ":new" has the internal name "sqlparam".  There is already a
bug report for triggers causing the plugin to prompt you for a value :

http://sourceforge.net/tracker/index.php?func=detail&aid=2021479&group_id=28383&atid=393414

Rob