هل أستطيع ان أضغ في الشرط Where ناتج خرج Procedure؟؟

Only stored functions are callable from SQL statements. Stored procedures cannot
be called unless invoked from a function that meets the preceding requirements.

The user-defined PL/SQL functions that are callable from SQL expressions must meet the following requirements:
• The function must be stored in the database.
• The function parameters must be input only and valid SQL data types.
• The functions must return data types that are valid SQL data types.
They cannot be PL/SQL-specific data types such as BOOLEAN, RECORD, or TABLE.
The same restriction applies to the parameters of the function.

The following restrictions apply when calling a function in a SQL statement:
• Parameters must use positional notation. Named notation is not supported.
• You must own or have the EXECUTE privilege on the function.

Other restrictions on a user-defined function include the following:
• It cannot be called from the CHECK constraint clause of a CREATE TABLE or ALTER TABLE statement.
• It cannot be used to specify a default value for a column.

Functions called from:
• A SELECT statement ,cannot contain DML statements.
• An UPDATE or DELETE statement on a table T ,cannot query or contain DML on the same table T.
• SQL statements ,cannot end transactions (that is,cannot execute COMMIT or ROLLBACK operations).
- A COMMIT or ROLLBACK statement.
- A session control statement (such as SET ROLE).
- A system control statement (such as ALTER SYSTEM).
- Any DDL statements (such as CREATE), because they are followed by anautomatic commit.