what is difference between procedure and function
- 10 Answers
- 13723 Views
- MCN Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhendu
Functions called from SQL have special restrictions:
Accept only IN parameters
cannot contain DML
cannot contain DDL - implies COMMIT
Accept and return only SQL datatypes (not PL/SQL
specific datatypes)
Must use positional notation
Must own or have EXECUTE privilege
Cannot contain transactional or session control
statements (eg. COMMIT, ROLLBACK, ALTER)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are the differences between char and varchar? : Sql dba
Does view store data in sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is over () in sql?
How to assign sql query results to pl sql variables?
Can we insert data into view?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is difference between mysql and postgresql?
What is rename in sql?
Is sql database free?
what are the properties and different types of sub-queries? : Sql dba
What is the use of prepared statement?
what is a relationship and what are they? : Sql dba
how can we destroy the cookie? : Sql dba
How can I see all tables in sql?
