RE:Paralelismo sobre Procedimientos almacenados
Espero funcione ...
-------------------------------------------------------------------------------------------------------
SQL> create table prb ( c varchar2(10));
Table created.
SQL> create or replace procedure prb1 is
2 begin
3 insert into prb values ('HOLA');
4 end;
5 /
Procedure created.
SQL> create or replace procedure prb2 is
2 begin
3 insert into prb values ('MUNDO');
4 end;
5 /
Procedure created.
SQL> create or replace function f1 return number is
2 begin
3 prb1;
4 return 1;
5 end;
6 /
Function created.
SQL> create or replace function f2 return number is
2 begin
3 prb2;
4 return 2;
5 end;
6 /
Function created.
SQL>
SQL> set serveroutput on
SQL> select f1, f2 from dual;
select f1, f2 from dual
*
ERROR at line 1:
ORA-14551: cannot perform a DML operation inside a query
ORA-06512: at "GI906664.PRB1", line 3
ORA-06512: at "GI906664.F1", line 3
ORA-06512: at line 1
SQL> declare
2 a number;
3 begin
4 a := f1+f2; dbms_output.put_line('SUMA: '||a);
5 end;
6 /
SUMA: 3
PL/SQL procedure successfully completed.
SQL>
SQL> select * from prb;
C
----------
HOLA
MUNDO
SQL>
------------------