Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
The SQL update looks like:
Function DoPrice(tmpProduct_code IN VARCHAR2, tmpDate IN Date) PROD_PRICE PriceTable.Price%TYPE; <dostuff> EXCEPTION WHEN NO_DATA_FOUND THEN PROD_PRICE := NULL; RETURN PROD_PRICE; WHEN OTHERS THEN RETURN PROD_PRICE;
'UPDATE Detail a SET a.Price = PRICING.DoPrice(a.PRODUCT_CODE (SELECT Process_Date FROM Transaction WHERE Trans_Ref_ID = Detail_Ref_ID)) ,<other items to set> ,a.Batch_ID = (select Batch_ID from Transaction FROM Transaction WHERE Trans_Ref_ID = Detail_Ref_ID) WHERE a.Batch_ID IS NULL';
Join the community of 500,000 technology professionals and ask your questions.