Surely we can call. if the procedure is using dml,then mark that procedure

can we call a procedure from a function?

Question Posted / rakesh

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

Please Help Members By Posting Answers For Below Questions

What is java sql drivermanager?

1103

What version is sql?

1037

What is the difference between the implicit and explicit cursors?

1054

What are the topics in pl sql?

975

What is the difference between instead of trigger and after trigger?

1013

Explain what is a view?

1066

What is bind reference and how can it be created?

1021

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2572

What are the qualities of 2nf?

1039

what are the differences between require and include, include_once and require_once? : Sql dba

1028

What are variables in pl sql?

1170

What is trigger in sql? Explain

999

What does rownum mean in sql?

1031

What are the different type of joins in sql?

956

What is the difference between truncate and drop statements?

1192