
هل أستطيع ان أضغ في الشرط Where ناتج خرج Procedure؟؟
#3
تاريخ المشاركة 29 March 2009 - 01:13 PM
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.
تم التعديل بواسطة TROYMAN, 29 March 2009 - 01:19 PM.
<<اللهم لا علـم لنا إلا ما علّمتنا إنك أنت العليــم الحكيــم>>
<<اللهم علّمنا ما ينفعنا و انفعنا بما علّمتنا و ازدنا علماً>>
Programmer (C#.Net,C++,ASP) & Oracle Developer