Advanced Search

Retornar Cursor Oracle para Java

/ Published in: PL/SQL
Save to your folder(s)
Procedimiento para retornar un Cursor y recorrerlo en Java

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. PROCEDURE pr_obtener_cursor    (PN_CODIGO     IN NUMBER,
  2.                                 PC_CURSOR     OUT Sys_Refcursor,
  3.                                 PV_ERROR      OUT VARCHAR2) IS
  4.  
  5.      lv_programa      VARCHAR2(100) := 'pr_obtener_cursor';
  6.  
  7.   BEGIN
  8.  
  9.     IF PN_CODIGO IS NULL THEN
  10.        Pv_error := 'El c�³digo no puede ser nulo';
  11.        RETURN;
  12.     END IF;
  13.  
  14.     OPEN PC_CURSOR FOR
  15.            SELECT *
  16.             FROM TABLA T
  17.            WHERE T.CODIGO= PN_CODIGO
  18.              AND T.ESTADO IN ('A', 'I');
  19.  
  20.   EXCEPTION
  21.     WHEN NO_DATA_FOUND THEN
  22.          pv_error:='C�³digo no existe';
  23.     WHEN OTHERS THEN
  24.          pv_error:= lv_programa ||'-'||SQLERRM;
  25.   END pr_obtener_cursor;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.