1.

What Restrictions Can Be Applied On Stored Functions, Which Are Called From Sql Statements?

Answer»

The main restrictions on stored FUNCTIONS that are CALLED from SQL statements are:

  •  These functions can use only POSITIONAL METHODS for passing the parameters.
  •  These functions can use only SQL specific datatypes. PL/SL datatypes, such as RECORD or TYPE, cannot be used.
  •  User should have EXECUTE privilege on the function to use it within SQL statements
  •  These functions cannot have the OUT and IN OUT parameter MODES

The main restrictions on stored functions that are called from SQL statements are:


Discussion

No Comment Found

Related InterviewSolutions