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 schema in sql?

518

what are date and time data types in mysql? : Sql dba

504

what is the difference between cluster and non cluster index? : Sql dba

557

What is the difference between an inner and outer join?

541

What is serial sql?

529

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

560

Show the two pl/sql cursor exceptions.

616

Explain raise_application_error.

644

How to rename a column in the output of sql query?

539

write an sql query to find names of employee start with 'a'? : Sql dba

583

Can 2 queries be executed simultaneously in a distributed database system?

649

What is sql scripting?

563

What is compound trigger?

561

Define union, minus, union all, intersect ?

556

how to check server status with 'mysqladmin'? : Sql dba

573