Question: what is the difference between call and exec in oracle?
Answer: CALL is Oracle SQL and should work everywhere. ... The data types of the parameters passed by the CALL statement must be SQL data types. They cannot be PL/SQL-only data types such as BOOLEAN. EXEC could be used to execute not only an SP, but an arbitrary statement.