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;

1856

Post New Zensar Programming Code AllOther Interview Questions


Zensar Programming Code AllOther Interview Questions


Un-Answered Questions

What is the default shell of solaris?

551


What is the difference between linux server and solaris server?

1785


What is difference between rollback and commit?

602


Explain system testing?

581


If an application has multiple classes in it, is it okay to have a main method in more than one class?

515






What is the difference between infogroup and infotype and how do you use and where?

674


What are the different components of sap business one client software ?

602


What is the function of having virtual internet protocol address (vip) in oracle rac?

1


Is angular dying because of react?

428


What is product attributes?

614


How can we implement a package in laravel?

492


List out the difference between textFile and wholeTextFile in Apache Spark?

268


hi friend i am going too attend for hpcl in this month please help me by sending written test question papers i am in the stream of E.E.E

1508


what is the difference between with core

1216


How can you copy forms from one client to other?

502