Interested to Buy Any Domain ? << Click Here >> for more details...
i want run following code on button click of view. i am trying to retrieve data from isc_order_details table and isc_product table. but after retriaval of data i m getting error like FIELD MUST BE ENTERED!! DECLARE m number; n number; CURSOR order_details IS SELECT PRODUCT_ORDER_QUAN,PRODUCT_ID FROM isc_order_details WHERE order_id=:isc_order_master.order_id; amount NUMBER (8,2):=0.0; alert number; BEGIN go_block('isc_order_details'); first_record; m:=:system.cursor_record; last_record; n:=:system.cursor_record; OPEN order_details; --for i in m..n loop FETCH order_details INTO :ISC_ORDER_DETAILS.PRODUCT_ORDER_QUAN,:ISC_ORDER_DETAIL S.PRODUCT_ID; IF order_details%FOUND THEN SELECT order_value,order_date INTO :ISC_ORDER_MASTER.ORDER_VALUE,:ISC_ORDER_MASTER.ORDER_D ATE FROM isc_order_master WHERE order_id=:ISC_ORDER_MASTER.ORDER_ID; SELECT product_desc,product_price INTO :ISC_ORDER_DETAILS.PRODUCT_DESC,:ISC_ORDER_DETAILS.PROD UCT_PRICE FROM isc_product WHERE product_id=:ISC_ORDER_DETAILS.PRODUCT_ID; next_record; END IF; EXIT WHEN order_details%NOTFOUND; END LOOP; last_record; CLOSE order_details; EXCEPTION when NO_DATA_FOUND then alert:=SHOW_ALERT('ENTER_DATA'); Go_Item('isc_order_master.order_id'); END;
2178Post New Zensar Programming Code AllOther Interview Questions
- Zensar C Interview Questions (4)
- Zensar Programming Languages AllOther Interview Questions (3)
- Zensar VB Script Interview Questions (2)
- Zensar TCP IP Interview Questions (1)
- Zensar ADO.NET Interview Questions (2)
- Zensar Microsoft Related AllOther Interview Questions (1)
- Zensar Oracle General Interview Questions (3)
- Zensar Oracle Forms Reports Interview Questions (11)
- Zensar SQL Server Interview Questions (3)
- Zensar MySQL Interview Questions (2)
- Zensar SQL PLSQL Interview Questions (10)
- Zensar Databases AllOther Interview Questions (2)
- Zensar Solaris General Interview Questions (1)
- Zensar Operating Systems General Concepts Interview Questions (1)
- Zensar Data Structures Interview Questions (1)
- Zensar WinRunner Interview Questions (1)
- Zensar QTP Interview Questions (6)
- Zensar Manual Testing Interview Questions (15)
- Zensar COBOL Interview Questions (1)
- Zensar JCL Interview Questions (1)
- Zensar DB2 Interview Questions (2)
- Zensar Core Java Interview Questions (4)
- Zensar Advanced Java Interview Questions (1)
- Zensar Servlets Interview Questions (1)
- Zensar Struts Interview Questions (1)
- Zensar Business Objects Interview Questions (6)
- Zensar Cognos Interview Questions (2)
- Zensar Informatica Interview Questions (17)
- Zensar SAS Interview Questions (2)
- Zensar Data Warehouse General Interview Questions (1)
- Zensar HR Questions Interview Questions (17)
- Zensar SAP Basis Interview Questions (1)
- Zensar SAP SD (Sales & Distribution) Interview Questions (1)
- Zensar SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- Zensar SAP HR (Human Resource Management) Interview Questions (1)
- Zensar Oracle Apps Technical Interview Questions (14)
- Zensar Oracle Apps Financial Interview Questions (4)
- Zensar Oracle Apps Manufacturing Interview Questions (1)
- Zensar Oracle Apps HRMS Interview Questions (2)
- Zensar Oracle Apps SCM Interview Questions (1)
- Zensar 86 Family Interview Questions (3)
- Zensar VLSI Interview Questions (1)
- Zensar Computer Security Interview Questions (1)
- Zensar Cloud Computing General Interview Questions (1)
- Zensar Engineering AllOther Interview Questions (1)
- Zensar Marketing Sales Interview Questions (1)
- Zensar Accounting AllOther Interview Questions (1)
- Zensar Call Centre AllOther Interview Questions (5)
- Zensar Everything Else AllOther Interview Questions (1)
- Zensar Puzzles Interview Questions (1)
- Zensar Placement Papers Interview Questions (1)
- Zensar Oracle Certifications Interview Questions (1)
- Zensar H1B Visa Interview Questions (1) Zensar Programming Code AllOther Interview Questions (1)
How can I get excel on my computer for free?
What is the complexity of bubble sort?
What does a derived class inherit from a base class a) Only the Public members of the base class b) Only the Protected members of the base class c) Both the Public and the Protected members of the base class d) .c file
Do we consider null values the same as that of blank space or zero?
What are the differences between tensorflow and pytorch?
State some major principles of agile.
what is the difference between nested subquery and correlated subquery?
What is difference between session and cookie?
How do I rename all the files from .htm to .html after copying them from a pc to a unix machine?
Write the logging in and out commands in aix.
How do I create a stored procedure in dbml?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are the disadvantages of object oriented programming?
Explain how are grasslands classified?
Explain the project tree in test director?
