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

Why is theta join required?

1155

How does stored procedure reduce network traffic?

1022

what is oracle database ? : Sql dba

1041

How do you define a foreign key?

1015

what is single byte over head in oracle..?

2414

Is mariadb a nosql database?

1066

What is online transaction processing (oltp)?

1030

What is asqueryable?

988

Can we join tables without foreign key?

968

What is self-join and what is the requirement of self-join?

1160

what is a unique key ? : Sql dba

1109

how to drop an existing table in mysql? : Sql dba

1061

What does cursor do in sql?

1036

What is clustered index in sql?

1065

Why do we use joins in sql?

981