UNION in proc called from Forms
From: Glen Siferd <siferd_at_admin.uwex.edu>
Date: Tue, 17 Aug 1999 15:19:45 -0500
Message-ID: <7pcg54$oq8$1_at_news.doit.wisc.edu>
We are using UNION in a cursor defined in a procedure that is then called from a Forms 5 trigger. The proc compiles and runs correctly outside of Forms, but the Forms compiler says the procedure object is invalid. Taking out the UNION seems to mollify the compiler. Is there a problem using that operator in Forms? Would it be helped by using position references instead of column aliases in the GROUP BY clause in the cursor? Thought this problem was corrected?
Date: Tue, 17 Aug 1999 15:19:45 -0500
Message-ID: <7pcg54$oq8$1_at_news.doit.wisc.edu>
We are using UNION in a cursor defined in a procedure that is then called from a Forms 5 trigger. The proc compiles and runs correctly outside of Forms, but the Forms compiler says the procedure object is invalid. Taking out the UNION seems to mollify the compiler. Is there a problem using that operator in Forms? Would it be helped by using position references instead of column aliases in the GROUP BY clause in the cursor? Thought this problem was corrected?
Thanks!
-- Glen Siferd 608/262-5965Received on Tue Aug 17 1999 - 22:19:45 CEST