oracle code

Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Koke

« Newer Snippets

Older Snippets »

Showing 1-2 of 2 total RSS

Debug logs in the database

How to log things in the database

Create the table:

create table TMP_LOG (HORA date, ENTRADA varchar(4000));

Write the things I need to the table:

INSERT INTO TMP_LOG (HORA, ENTRADA) VALUES(SYSDATE, 
  'V_NOM_DESTINATARIO1: '||V_NOM_DESTINATARIO1||', V_DOM_DESTINATARIO1: '||V_DOM_DESTINATARIO1||
  ', P_NOM_DESTINATARIO_2: '||P_NOM_DESTINATARIO_2||', P_DOM_DESTINATARIO_2: '||P_DOM_DESTINATARIO_2||
  ', B_DESTINATARIO: '||B_DESTINATARIO||
  ', V_NOM_DESTINATARIO2: '||V_NOM_DESTINATARIO2||', V_DOM_DESTINATARIO2: '||V_DOM_DESTINATARIO2);

Consult the things written:

select * from tmp_log order by hora desc;

Dont forget to drop it at the end:

drop table TMP_LOG;

to database log oracle debug by koke24 on May 30, 2007

Mostar los resultados de un cursor

Esto muestra los resultados de un cursor en la ventana de pruebas del SQL Developer

Declaración de las variables

c1 varchar2(200);
c2 varchar2(200);
c3 varchar2(200);

Código en sí

fetch v_Return into c1, c2, c3;
loop
  EXIT WHEN v_Return%NOTFOUND;
  DBMS_OUTPUT.PUT_LINE(c1||', '||c2||', '||c3);
  fetch v_Return into c1, c2, c3;
end loop;
close v_Return;

Ejemplo del código completo:

DECLARE
  PVCOD_DESPACHO NUMBER;
  PVCOD_IDIOMA VARCHAR2(200);
  v_Return PG_SGIE_Types.cursor_type;
  c1 varchar2(200);
  c2 varchar2(200);
  c3 varchar2(200);
BEGIN
  PVCOD_DESPACHO := 2792;
  PVCOD_IDIOMA := '1';

  v_Return := FU_LISTAENVIOSDESPACHO(
    PVCOD_DESPACHO => PVCOD_DESPACHO,
    PVCOD_IDIOMA => PVCOD_IDIOMA
  );
  -- Modify the code to output the variable
  --DBMS_OUTPUT.PUT_LINE('v_Return = ' || v_Return);
  
  fetch v_Return into c1, c2, c3;
  loop
    EXIT WHEN v_Return%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(c1||', '||c2||', '||c3);
    fetch v_Return into c1, c2, c3;
  end loop;
  close v_Return;
END;

to oracle debug by koke24 on May 04, 2007