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;
2201Post 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)
What is cache-coherency?
Is it safe to delete previous windows installation files?
can u tell me any JAM topics.........and answers also...plz send me.........e-mail: anitha839@gmail.com
What is the difference between diffraction and interference?
Explain me how will you create a pills navigation menu?
we have virtual function then why need of pure virtual function.
What is the definition of responsibility?
Who was the first person to recognize that true flies have two wings and gave them the name ?Diptera??
If anyone would like to know or practice for FEWA papers contact me on mohamedrashad2@hotmail.com Just completed the supervisor exam in April 2021
What are the different types of leases?
Please brief not about xsd,xslt & xml?
An advertiser wants to increase the quality score of a low-perofrming keyword. Which approach would you recommend?
Tell me why did you select accounting as your profession?
What is defer offscreen images?
Does empty check for null?
