title: Print varchar in Pro*c from Oracle Procedure
body: <p>I need get the output of a VARCHAR2  variable in PRO*C. This variable  comes from a Oracle procedure. This is the thing:</p>
  
  <p>This work fine,</p>
  
  <pre><code>bzero(d_fecha_ejecucion.arr,20); 
   EXEC SQL SELECT
   TO_CHAR(SYSDATE,'dd-mon-yy hh24:mi:ss') INTO :d_fecha_ejecucion FROM
   DUAL;           
   sprintf(c_msg,"---&gt;FECHA EJECUCIÓN: [%s]",(char *)d_fecha_ejecucion.arr);
  </code></pre>
  
  <p>But when I try to get a variable (VARCHAR SV_desc_error) from procedure like this:</p>
  
  <pre><code> EXEC SQL EXECUTE
   BEGIN
   PACKAGE.PROCEDURE_PR(:SN_num_ev, :SN_cod_msjerror,:SV_desc_error);
   END;
  END-EXEC;
  
  bzero(SV_desc_error.arr,4000);
  SV_desc_error.len = (unsigned short)strlen((char *)SV_desc_error.arr);
  
  sprintf(c_msg,"---&gt;Out PACKAGE.PROCEDURE_PR(SN_num_ev: [%d],SN_cod_msjerror: [%d],SV_desc_error: [%s])",SN_num_evento,SN_cod_msjerror,(char *)SV_desc_error.arr);
  </code></pre>
  
  <p>Don't work...the variable return empty</p>
  
  <p>I test with a anonymous block and works...</p>
  
  <p>So, who i can get this variable?
  Thank.</p>