Whats wrong with this procedure execution script? RSS

• • Reply
  

  JavierVera

  Member

  112 Points

  63 Posts

  Whats wrong with this procedure execution script?

  Nov 21, 2012 06:26 PM|LINK

  create or replace
  PROCEDURE "LOGIN_SQL" (
  P_COD_LOGIN_OPE IN VARCHAR,
  P_COD_CONTRASENIA_OPE IN VARCHAR)

  AS
  v_IDE_USUARIO_USU GLS_GR_MAE_USUARIO.IDE_USUARIO_USU%TYPE;
  v_DES_NOMBRES_USU GLS_GR_MAE_USUARIO.DES_NOMBRES_USU%TYPE;
  v_DES_APEMATERNO_USU GLS_GR_MAE_USUARIO.DES_APEMATERNO_USU%TYPE;
  v_DES_APEPATERNO_USU GLS_GR_MAE_USUARIO.DES_APEPATERNO_USU%TYPE;
  v_DES_MOVIL_USU GLS_GR_MAE_USUARIO.DES_MOVIL_USU%TYPE;
  v_COD_ESTADO_EST GLS_GR_MAE_USUARIO.COD_ESTADO_EST%TYPE;
  v_COD_LOGIN_USU GLS_GR_MAE_USUARIO.COD_LOGIN_USU%TYPE;
  v_COD_CONTRASENIA_USU GLS_GR_MAE_USUARIO.COD_CONTRASENIA_USU%TYPE;

  v_flg_sexo_usu GLS_GR_MAE_USUARIO.flg_sexo_usu%TYPE;

  BEGIN
  --open p_recordset for
  SELECT
  U.IDE_USUARIO_USU,
  U.DES_NOMBRES_USU,
  U.DES_APEMATERNO_USU,
  U.DES_APEPATERNO_USU,
  U.DES_MOVIL_USU,
  U.COD_ESTADO_EST,
  U.COD_LOGIN_USU,
  U.COD_CONTRASENIA_USU,
  U.COD_ESTADO_EST,
  u.flg_sexo_usu
  INTO
  v_IDE_USUARIO_USU ,
  v_DES_NOMBRES_USU ,
  v_DES_APEMATERNO_USU,
  v_DES_APEPATERNO_USU,
  v_DES_MOVIL_USU ,
  v_COD_ESTADO_EST,
  v_COD_LOGIN_USU ,
  v_COD_CONTRASENIA_USU ,
  v_COD_ESTADO_EST ,
  v_flg_sexo_usu
  FROM GLS_GR_MAE_USUARIO U
  WHERE
  U.COD_LOGIN_USU =P_COD_LOGIN_OPE AND
  U.COD_CONTRASENIA_USU = P_COD_CONTRASENIA_OPE AND
  U.COD_ESTADO_EST='1';
  END LOGIN_SQL;
  /

  It compiles so i belive it is nothing wrong wth the procedure itself

  Then i want to see the result of this stored procedure by using:

  SET SERVEROUTPUT ON;
  DECLARE
  P_COD_LOGIN_OPE VARCHAR2(200);
  P_COD_CONTRASENIA_OPE VARCHAR2(200);
  BEGIN
  P_COD_LOGIN_OPE := '41110001';
  P_COD_CONTRASENIA_OPE := '41110001';

  LOGIN_SQL(
  P_COD_LOGIN_OPE => P_COD_LOGIN_OPE,
  P_COD_CONTRASENIA_OPE => P_COD_CONTRASENIA_OPE
  );
  END;

  any idea why results are not being shown? i'd like to see the resultset given by the execution.

  Wha? Wait wait... who is you? you ain't my girlfriend... she was wearing blue
• • Reply
  

  Lannie

  Contributor

  3738 Points

  728 Posts

  Re: Whats wrong with this procedure execution script?

  Nov 22, 2012 04:31 AM|LINK

  In SQL console,

  does your SELECT statement with the same WHERE filter conditions with hard coded values

  return any records??

  Perhaps your query returns NO RECORDS.