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


Please Help Members By Posting Answers For Below Questions

What is time based sql injection?

685


Why is sql*loader direct path so fast?

797


What are all the different normalization?

744


What are the types of variable use in pl sql?

742


How to select all records from the table?

803






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?

758


What is the difference between sum and count in sql?

718


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

733


What is the function that is used to transfer a pl/sql table log to a database table?

730


What are dml commands?

735


What are different types of queries in sql?

732


Describe different types of general function used in sql?

727


How delete all data from table in sql?

752


Define concurrency control. : Transact sql

788


What is flag in sql?

736