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 normalization means?

966

what are the type of locks ? : Sql dba

958

What are the properties of a transaction?

1128

Why do we need sharding?

984

Which certification is best for sql?

981

discuss about myisam index statistics collection. : Sql dba

946

What is an inconsistent dependency?

1044

What is not equal in sql?

1114

Explain the types of joins in sql?

1032

What is the requirement of self-join?

1117

What is sql not null constraint?

1023

What is meaning of <> in sql?

1065

What is the max nvarchar size?

959

what is meant by urlencode and urldocode? : Sql dba

1172

What is the purpose of the sql select top clause?

1102