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

How do I view a table in sql?

947

How to combine two stored procedures in sql?

1119

what is the use of friend function? : Sql dba

970

What does the acronym acid stand for in database management?

982

What is auto increment in sql?

1060

What is the difference between left and left outer join?

891

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1000

What is view? Can we update view

1352

Is pl sql still used?

924

What does data normalization mean?

896

How does one load ebcdic data? : aql loader

1092

What do you mean by rowid?

914

Is left join inner or outer by default?

972

What is an inconsistent dependency?

978

Can we use rowid as primary key?

941