Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Zensar Programming Code AllOther Interview Questions
Questions Answers Views Company eMail

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;

 1874

Post New Zensar Programming Code AllOther Interview Questions


Zensar Programming Code AllOther Interview Questions


Un-Answered Questions

Explain the processes used for operating business applicatio

504

Can an mdb be a message producer or both a producer and consumer? : BEA Weblogic

513

How do you configure the automatic payment program?

566

Should model locator as a singleton class? Can't we instantiate this class as like normal class?

5

How is data stored in mongodb?

1




How do I uninstall and reinstall windows defender?

449

What are the classes in c++?

636

Is WCT paid to be considered as overhead during costing in construction firm?

1514

What is sap data services?

17

Which type of memory which is fast and temporarily stores the data which are immediately required for use?

631

What are the different features of ms excel?

408

Which is better iis or apache?

525

what is thresold of perception

1461

which technology use in bikes

1534

What are the three stages to build any model in machine learning?

60