Result set procedure that returns the products for a particular category that will be released in the next month.Makes use of the
PRODUCT_DETAILSview to demonstrate that a select against a view is treated the same as a table.Shows how to define a result set procedure and one form of the row data type. Introduces the concepts of cursors.The use of
get diagnosticsavoids any real need to cover condition handlers at this stage.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40