CREATE SEQUENCE uniqueNum_s START WITH 1
INCREMENT BY 1;
CREATE OR REPLACE TRIGGER hhp_calendar
BEFORE INSERT ON hhp_calendar FOR EACH ROW
DECLARE
v_id id%type;
BEGIN
SELECT uniqueNum_s.nextval INTO v_id FROM DUAL;
:new.id = v_id;
END;
I get an error stating that dpch: uniqueNum_s is invalid and can't be initialized.
Any thoughts getting this to work or can anyone recommend a more appropriate forum?
thanks.
> I don't know what version of Oracle you're using, but all of the
> documentation is available online at OTN. Here's the link for all of
> the Oracle9i documentation: http://otn.oracle.
> com/documentation/oracle9i.html <http://otn.oracle.
> com/documentation/oracle9i.html> . If you have need for other versions,
> there are also links on that same page for other versions as well.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
