View the Exhibit. You have placed the following code in a Post insert trigger on the Orders block:

SELECT orders_seq.NEXTVAL INTO :orders.order_id FORM SYS.dual; You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID. As the SUMMIT user, you run the form to test it. You are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit. What is the probable cause of this error?

Question

View the Exhibit. You have placed the following code in a Post insert trigger on the Orders block:

SELECT orders_seq.NEXTVAL INTO :orders.order_id FORM SYS.dual; You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID. As the SUMMIT user, you run the form to test it. You are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit. What is the probable cause of this error?

Accepted Answer

A. The code should be in Pre_insert trigger instead

Answer

B. The code should be in a database trigger instead

Answer

C. You should change the code to select the sequence number from SUMMIT.dual instead.

Answer

D. You should create the sequence in the database, because the runtime error is an indication that is

Answer

E. You should assign a temporary value to the Order_Id item before saving the form.

View the Exhibit. You have placed the following code in a Post insert trigger on the Orders block: SELECT orders_seq.NEXTVAL INTO :orders.order_id FORM SYS.dual; You have also set Item properties…

Question

Exhibit

Options

How the community answered

Community Discussion