The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table.
You want to update the Order Entry form to display the additional data. You open the Layout Editor for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. You use the text item tool to create a new text item on the canvas, then open its Property Palette and set the Name property to ORDER_STATUS and the Column Name property to Order_Status. When you run the form to test it, you receive the error “FRM 40505 ORACLE error unable to perform query”.
What could be the cause of this error?
A.
You did not change the default value for the Data Type property of the Order_Status text item.
B.
You did not modify the WHERE clause of the Orders block to include the ORDER_STATUS column.
C.
You did not change the default value for the Database Item property of the Order_Status text item.
D.
You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item.
E.
You did not define the Column Name in uppercase so that the column value can be retrieved from the database.