السلام عليكم
هل أستطيع ان أضغ في الشرط where ناتج خرج procedure ؟؟

نعم يكمنك وضع خرج procedure فى شرط ال whereولكن اولا يتم وضع خرج procedure فى متغير ثم بعد ذلك وضع المتغير فى شرط ال WHERE .

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.

تم تعديل 29 مارس 200916 سنة بواسطة TROYMAN