|
-
Just a comment about this query:
CREATE OR REPLACE TRIGGER RF_PROD_BOM_INS_TRG
BEFORE INSERT ON RF_PRODUCT_BOM
FOR EACH ROW
Declare
V_SeqVal Number;
BEGIN
Select F_PROD_BOM_SEQ.NEXTVAL Into V_SeqVal From Dual;
:New.PBRFNBR = V_SeqVal;
END;
Doing a similar thing in Oracle 9i, I noticed that
:New.PBRFNBR = V_SeqVal;
should be
:New.PBRFNBR := V_SeqVal;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|