OraFAQ Forum: SQL & PL/SQL » trigger problem

Home » SQL & PL/SQL » SQL & PL/SQL » trigger problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

trigger problem [message #254672]

Fri, 27 July 2007 07:50

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

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What tool are you using to create that trigger? A quick Google lead me to this.

MHE

Report message to a moderator

Re: trigger problem [message #254686 is a reply to message #254675]

Fri, 27 July 2007 08:51

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

Report message to a moderator

Previous Topic:	order
Next Topic:	Ref cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 13:00:28 CST 2024