What Are The Restrictions On Functions That Are Called Within Sql Sta

1.	What Are The Restrictions On Functions That Are Called Within Sql Statements?
Answer» The functions that are called within SQL STATEMENTS have the following restrictions: They must be stored in a database. They cannot modify any database table. They can only take the IN parameter modes. The OUT and IN OUT parameter modes are not allowed in a function. They can only use valid SQL datatypes, such as NUMBER, VARCHAR2, and DATE. HOWEVER, they cannot use PL/SQL datatypes, such as BOOLEAN, RECORD, and TYPE. The return type of a function should be of SQL DATATYPE. They cannot have the COMMIT and ROLLBACK statements. They cannot have the ALTER SESSION and ALTER SYSTEM commands. The functions that are called within SQL statements have the following restrictions:

What Are The Restrictions On Functions That Are Called Within Sql Statements?

Answer»

The functions that are called within SQL STATEMENTS have the following restrictions:

They must be stored in a database.
They cannot modify any database table.
They can only take the IN parameter modes. The OUT and IN OUT parameter modes are not allowed in a function.
They can only use valid SQL datatypes, such as NUMBER, VARCHAR2, and DATE. HOWEVER, they cannot use PL/SQL datatypes, such as BOOLEAN, RECORD, and TYPE.
The return type of a function should be of SQL DATATYPE.
They cannot have the COMMIT and ROLLBACK statements.
They cannot have the ALTER SESSION and ALTER SYSTEM commands.

The functions that are called within SQL statements have the following restrictions: