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

Why cross join is used?

637


What is record in pl sql?

599


What is the usage of when clause in trigger?

571


What is record data type?

518


How many commands are in sql?

531






Are views faster than queries?

550


How many commands are there in sql?

553


What is primary key and foreign key with example?

499


What is normalization in a database?

616


What is cartesian join in sql?

561


Name the operator which is used in the query for pattern matching?

508


What are system versioned tables?

553


What are actual parameters and formal parameters?

574


What are the different operators available in sql?

583


what is auto increment? : Sql dba

579