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;

 1878

Post New Zensar Programming Code AllOther Interview Questions


Zensar Programming Code AllOther Interview Questions


Un-Answered Questions

MOP can be processes ? and after processing can it be use for industrial purpose and pharmaceutical purpose ? can it be process for injectable use ?

1587

What is a viewmodel in android?

515

What are the differences between in and exists clause?

571

what are the features of jquery

473

What is the replace tool in word?

366




What are the benefits of using go programming?

1

Why is ngoninit called twice?

714

What return value must conversion operators have in their declaration?

612

What is bms map?

663

What are the configurations for bank statement processing? : fi- general ledger

758

What is difference between action support and action function?

224

How do you create empty strings in c#?

517

Tell me is jquery a w3c standard? : jquery mobile

471

Can you install wordpress on your computer?

108

How do you transfer changed master data and production version to scm system?

167