Help about UTL_FILE

From: News mad <rcabello_at_abonados.cplus.es>
Date: Tue, 29 Sep 1998 08:37:29 +0200
Message-ID: <6upufa$otg$1@talia.mad.ibernet.es>

Please, somebody knows what happenned with UTL_FILE, it's necesary to run any script on server to use this package.

I have stablished the parameter UTL_FILE_DIR = \\pdcsi\depart\alma\cargas\out in INIT---.ora file, but when i used this package on mi PL/SQL package, i obtain the next error: User_defined_exception.

   The exception is INVALID_OPERATION when i try to use the FOPEN function. i have defined the code you could see:

PROCEDURE DCRG_COMPR_PEDIDOS IS   Fichero UTL_FILE.FILE_TYPE;
  NomFichero VARCHAR2(30);
  Buffer VARCHAR2(1000);
  CodPedido PEDIDOS.CODIGO_PEDIDO%TYPE;

   CURSOR Pedidos_Prep_Envio IS

          SELECT Codigo_Pedido
          FROM   Pedidos
          WHERE  Fecha_Preparacion_Envio IS NOT NULL
          AND    Fecha_Envio IS NULL
          AND    Anulado = 'N'
          AND    Retenido = 'N'
          FOR UPDATE OF Fecha_Envio;

   CURSOR C_Pedido (CodigoPedido  PEDIDOS.CODIGO_PEDIDO%TYPE) IS
          SELECT Codigo_Ext_Pedido
          FROM   Pedidos
          WHERE  Codigo_Pedido = CodigoPedido;

   Reg_Pedido C_Pedido%ROWTYPE;

   Tabla_Compr cgc$AACMPINC_COMPROBACION.cgc$rec_tab ; BEGIN DBMS_OUTPUT.ENABLE(20000); NomFichero := 'ALM'||TO_CHAR(SYSDATE,'MMDD')||'1.ASC';

Fichero := UTL_FILE.FOPEN('\\PDCSI\DEPART\ALMA\CARGAS\OUT', NomFichero, 'a');

FOR P IN Pedidos_Prep_Envio LOOP
BEGIN

• Genera la tabla PL/SQL de comprobación del pedido. cgc$AACMPINC_COMPROBACION.QRY (Tabla_Compr, P.codigo_pedido);
• Incluye líneas del pedido en fichero de texto FOR i IN 1 .. Tabla_Compr.COUNT LOOP BEGIN ..............

I hope somebody can help me about this problem.

Ricardo.... =8-) Received on Tue Sep 29 1998 - 01:37:29 CDT