Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2012
    Location
    Guayaquil Ecuador
    Posts
    4

    Unanswered:

    ----HELPMEEEEEEEE


    SQL> set colsep '|'
    SQL> set pagesize 9000
    SQL> set linesize 9999
    SQL> set termout off
    SQL> set heading on
    SQL> set trimspool on
    Cannot SET TRIMSPOOL

    SQL> set feedback off
    SQL> spool SELECT A.ID_SERVICIO, A.DESCRIPCION FEATURES_INCONSISTENTES, 'SMS INACTIVO EN AXIS Y ACTIVO EN TECNOTREE' ESCENARIOS, A.FECHA,'SMS' FROM BITACORA_REPL A WHERE A.FECHA < SYSDATE AND A.ESTADO='SMS' AND A.PROCESO='INACT_AXIS-ACT_TECNOTREE'
    Started spooling to

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQL> spool capture.log
    SQL> SELECT A.ID_SERVICIO, A.DESCRIPCION FEATURES_INCONSISTENTES, 'SMS INACTIVO EN AXIS Y ACTIVO EN TECNOTREE' ESCENARIOS, A.FECHA,'SMS' FROM BITACORA_REPL A WHERE A.FECHA < SYSDATE AND A.ESTADO='SMS' AND A.PROCESO='INACT_AXIS-ACT_TECNOTREE'
    SQL> SPOOL OFF
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2012
    Location
    Guayaquil Ecuador
    Posts
    4
    I do not understand your message, it is assumed that this is a forum where one consults, so postie here, because do not know how to solve this error. by the way I speak Spanish.

  4. #4
    Join Date
    Jun 2012
    Location
    Guayaquil Ecuador
    Posts
    4
    thanks, is that I had read your message footer and saw the answer hahaha million thanks I will try greetings

    gracias por contestar

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I do not understand your message, it is assumed that this is a forum where one consults, so postie here, because do not know how to solve this error.
    ERROR? What Error?
    I don't see any error in either of your two posts.
    How can we reproduce your problem?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2012
    Location
    Guayaquil Ecuador
    Posts
    4
    I generate a report with extension. Txt, but when I generate the spool file I get warped me be ordained, but I tried and that measures are not put if someone can give me a solution thanks.
    posting them part of the spool:
    cat>$Ruta/$SQL_FILE$i.sql<< EOF
    set colsep '|'
    set pagesize 5000
    set linesize 4000
    set termout off
    set heading on
    set trimspool on
    set feedback off

    spool $Ruta/$REP_FILE$i.txt
    $QUERY;
    spool off
    exit;
    EOF

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by aracelly3980 View Post
    I generate a report with extension. Txt, but when I generate the spool file I get warped me be ordained, but I tried and that measures are not put if someone can give me a solution thanks.
    posting them part of the spool:
    ... Etc ...
    No podemos entender lo que te esta pasando pues no podemos ver lo que tu estas viendo.
    Tenes que copiar e incluir la informacion completa de tu sesion, sobre todo, incluir el codigo y los mensages de error.

    Translation:
    We cannot understand what are experiencing, we cannot see what you are seeing.
    You need to copy and paste the complete session information including the code and error messages.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •