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)
Where are Hadoop’s configuration files located?
What is a sequence in python?
Does wc count spaces?
How can two components who are not related to each other, interact with each other in lightning ?
What is the use of compact repository?
Why triggers are used?
What percent of FDI is allowed in Single Brand Retailing and Multi Brand Retailing?
What are prompted filters? Have you ever used them? Where?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is Pradhan Mantri Jeevan Jyoti Bima Yojana?
What are ranges?
What are the json objects?
What are the core wpf assemblies?
Is inner join faster than left join?
What is buffer and example?
