-- Crea Tabla (Sección 2)
CREATE GLOBAL TEMPORARY table TMP_PRODS_SAL
   (V_Prod varchar2(13),
    V_Indice NUMBER GENERATED ALWAYS  AS IDENTITY) ON COMMIT DELETE ROWS;

-- Ejemplo para Retornar el campo IDENTITY (Sección 3)
SET SERVEROUTPUT ON
DECLARE
  VV_Indice TMP_PRODS_SAL.V_Indice%TYPE;
  VV_Prod varchar2(13);
BEGIN
        begin
            VV_Prod:= '1234567890123';
            insert into TMP_PRODS_SAL (V_Prod) values(VV_Prod);
    --        VV_Indice:= SCOPE_IDENTITY();
    --        RETURNING TMP_PRODS_SAL.V_Indice INTO VV_Indice;
    --        SELECT SCOPE_IDENTITY() AS SEQ;
        end;
        DBMS_OUTPUT.put_line('UPDATE ID=' || VV_Indice);
end;

-- Lectura de Tabla (Sección 4)
select * from TMP_PRODS_SAL;

-- Borrar Registros (Sección 5)
 commit;