1 Reply Latest reply on Apr 2, 2014 3:49 PM by rp0428

    SQLDEVELOPER 4.0.1 Bug on Generated External Table SQL statement by SQL DEVELEOPER

    Ckurt

      Hi,

       

      The issue is still going on the new release (4.0.1) from Version 3.X.X.

      The issue is wrong SQL statement of External table generated by Sql Developer.

       

      In the ORGANIZATION EXTERNAL section there are badfile, discardfile logfile and location parameters take place in it.

      But if you have look at that mentioned parameters strings , they have whitespace between first single quote and first letter of file name. Which means if you want to use this generated sql with the way of copy &paste into SQL work Sheet the table which is creatad with this sql is not working properly, the source file will not found beacuse of white space.

       

      Example is below(look at the characters next to badfile 'AS400_STAGE_LOG': string );

       

      CREATE TABLE .....................................

      ................................

      ................................

        ORGANIZATION EXTERNAL

          (

              TYPE ORACLE_LOADER DEFAULT DIRECTORY "AS400_STAGE" ACCESS PARAMETERS ( records delimited BY newline CHARACTERSET UTF8

      badfile 'AS400_STAGE_LOG':' SALES_CHANNEL_%p_%a.bad'

      discardfile 'AS400_STAGE_LOG':' SALES_CHANNEL_%p_%a.discard'

      LOGFILE 'AS400_STAGE_LOG':' SALES_CHANNEL_%p_%a.log'

      SKIP 1 FIELDS TERMINATED BY ";" MISSING FIELD VALUES ARE NULL )

      LOCATION ( "AS400_STAGE":' SALES_CHANNEL.csv' )   

      );

       

      Is there any work arround or method to fix this.

       

      Best regards,

       

      Cenk