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;
2276Post 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)
Define ramp limit in ab initio?
How to write a program for machine which is connected with server for that server automatically wants to catch the time for user of that machine?
Difference between idoc and idoc type?
What is the difference between depreciation and amortization?
behaviour of capacitor & inductor in ac circuits at t=0 & t=infinity.
What is ecc in reference to ram?
advantages and disadvantages of international trade
How do I separate development from production environment?
What are the characteristics of management?
What is constraint satisfaction problems?
What are global variables in php?
Maximum cement content in 1cum for RCC and PSC? (please give IS,IRC referance?
What is where exe?
When we use a context? : sap bobi
Do you know the languages supported for android development?
