can we call a procedure from a function?
Answer Posted / rakesh
Surely we can call.
if the procedure is using dml,then mark that procedure as
PRAGMA AUTONOMOUS_TRANSACTION.
then use that procedure in function.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is time based sql injection?
Why is sql*loader direct path so fast?
What are all the different normalization?
What are the types of variable use in pl sql?
How to select all records from the table?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the difference between sum and count in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is the function that is used to transfer a pl/sql table log to a database table?
What are dml commands?
What are different types of queries in sql?
Describe different types of general function used in sql?
How delete all data from table in sql?
Define concurrency control. : Transact sql
What is flag in sql?