Home » SQL & PL/SQL » SQL & PL/SQL » trigger problem
icon5.gif  trigger problem [message #254672] Fri, 27 July 2007 07:50 Go to next message
beesman
Messages: 2
Registered: July 2007
Junior Member
Hi all,

First time here, so please be gentle Razz

I'm trying to execute the following SQL script (Oracle 10g on Solaris):

CREATE OR REPLACE TRIGGER pk_histories_trigger
   BEFORE INSERT
   ON histories
   FOR EACH ROW
BEGIN
   SELECT pk_histories.NEXTVAL
   INTO   :NEW.ID
   FROM   DUAL;
END;


However, this gives me the following error message:

[Error Code: 17041, SQL State: null]  Missing IN or OUT parameter at index:: 1


I really don't know where to start debugging - any help would be much appreciated.

[Updated on: Fri, 27 July 2007 08:03] by Moderator

Report message to a moderator

Re: trigger problem [message #254675 is a reply to message #254672] Fri, 27 July 2007 08:06 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What tool are you using to create that trigger? A quick Google lead me to this.

MHE
Re: trigger problem [message #254686 is a reply to message #254675] Fri, 27 July 2007 08:51 Go to previous message
beesman
Messages: 2
Registered: July 2007
Junior Member
Yes, I'm using DbVisualizer! Executing the script using PL/SQL did the trick.

Thanks for the tip. Razz


Previous Topic: order
Next Topic: Ref cursor
Goto Forum:
  


Current Time: Wed Dec 07 04:52:18 CST 2016

Total time taken to generate the page: 0.10630 seconds