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 are different methods to trace the pl/sql code?

1094

How many types of index are there?

1020

How many sql core licenses do I need?

931

Why schema is used in sql?

1029

What is java sql drivermanager?

1067

How do I make sql search faster?

982

what are myisam tables? : Sql dba

1016

Why do we use sql constraints?

1153

What is the difference between a subquery and a join?

1074

How do I view output in sql developer?

1067

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1181

Can we use pl sql in sql server?

1063

Name three sql operations that perform a sort.

988

Can we debug stored procedure?

1011

How does postgresql compare to oracle/db2/ms sql server/informix?

1017