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;

 1869

Post New Zensar Programming Code AllOther Interview Questions


Zensar Programming Code AllOther Interview Questions


Un-Answered Questions

Explain .live()? : jquery mobile

473

What is the shortcut to hide entire row?

303

What are matchcodes?

545

Who is the founder of TCS?

681

What is flush () in c++?

569




Explain the importance of capitalization?

606

What are Types of operations?

848

Is div used in html5?

441

what are the Types of End User in dbms?

2758

What are governor limits in salesforce.com?

202

how to suspend a heavy density powder in alcohol

1628

How do you comment and uncomment in visual studio?

460

300m long and 30kw inductive loade 3phase supply how many size cable required

985

Compare ansible vs puppet?

1

What is the difference between icomparer and icomparable in c#?

454