Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by berlak
-
Urgent: problem in jdev9031
The classpath is not set properly. There might be some classes in your classpath that shouldn't be there. Check the Java Option field (JDeveloper: Project Settings -> Configurations -> Development -> Runner -> Java Options) if there is any "-classpath" option specified there. Leave...- berlak
- Post #4
- Forum: Oracle: JDeveloper
-
Triggers refining a statement
Here is the working solution: CREATE TRIGGER archive AFTER INSERT ON order REFERENCING NEW AS new FOR EACH ROW MODE DB2SQL BEGIN ATOMIC DECLARE v_max INTEGER; SET v_max = (SELECT COUNT(*)FROM order WHERE cno = new.cno); IF v_max = 50 THEN INSERT INTO order_archive (oa_cno, oa_bno, oa_when...
