Stored Procedure Vs Function

A function is a store procedure indeed, and you can use autonomous transactions to do some DML

Implicit cursor is created automatically,opened automatically and closed automatically.it holds exactly one record. in case none or more than 1 record are retrieved, an exception is raised and that result into error or abnormal termination of program. whereas explicit cursor is created,opened and closed explicitly.it is created to hold 1 or more records.FETCH statement is used to retrieve the record.in order to check whether the fetch statement has retrieve the record, attribute %NotFound is used.