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;
2014Post 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)
Explain the difference between “==” and “===”?
How to keep file validation in apache-wicket if no file has been selected?
hi.. sap sd is installed in my PC .i m unable to start becoz ,i have given wrong password many times and it's locked.please tell me how can i open SAP logon. tell the process at my id dst.noida@rediffmail.com please advance thanx
What are mysql functions?
i am interested in refrigeration and air conditioning systems.please send me name of this type of company in baroda,gujarat.
What are the benefits of ADO.NET?
What does || mean in programming?
What are the advantages of zend framework?
What is a checkpoint in machine learning?
Explain about measure() method? When this measure() method is called?
What are four access categories,which one has more priority?
How to overcome pesticide paradox?
What would you say when HR asks you "Please do help me understand why are you looking for a non-technical profile?"
How are elements stored in hashset?
Can you explain eigenvalue and eigenvector?
