Error/Normal Returns(?) Procedure
Date: 12 Jun 1998 02:03:05 GMT
Message-ID: <6lq28p$btq$1_at_clarknet.clark.net>
Today I worked on the Oracle Forms 4.5 with the several procedures.
I noticed that one key-next-item trigger had two together procedures.
Both procedures were almost similar processes, but I wonder why both procedures were at the two lines together - reversed on the other trigger. It didn't bother but I was curious. Late I decided adding the MESSAGE commands to keep track on the process as I inserted after each procedure line. After running, I noticed that 1st output MESSAGE was missing.
My experience skill about Sigma 9 assembly langugae code, it had the error and normal returns on next or 2nd instruction line after call the subprograms or the library calls.
So I put the NULL command after the procedure line for the error return for null action.
The result was that I got 1st MESSAGE output finally.
I think I need to search or look for this details on the manuals which give us the kind of returns, but I still not see any error and normal returns yet. Better to watch out on the procedures together on PL/SQL statement or trigger if both difference procedure together on which return or skip the next procedure pending the error process or normal process.
I still look for this answer on the manuals tomorrow or next week.
Any comment about this trick or clever method on the PL/SQL procedure????
Sam
---------------Samuel E. Jones --------------------------Received on Fri Jun 12 1998 - 04:03:05 CEST