1 2 Previous Next 29 Replies Latest reply on Aug 17, 2010 5:05 PM by 747821

    Illegal combination of non-alphanumeric characters

    747821
      i create a Control File
      load data
      infile *
      append
      into table iil_person
      FIELDS TERMINATED BY ','
      (
       num               integer external,
       firstname          char,
       gender_code     char,
       birth_dttm          char,
       inactive_date     char,
       last_name          char
      )
      my text file data is
      1,zafar,001,12,31122009,habib
      when i execute the sql loader from oracle apps it gives me error
      Illegal combination of non-alphanumeric characters

      Regards
      RanChoo
        • 1. Re: Illegal combination of non-alphanumeric characters
          706888
          Hi,

          simply one small remarks:
          if you use "infile *" it means that the data is iinside the control file, is it the case? (otherwise specify the filename that contains the data)

          have a nice day.

          Edited by: user11268895 on Aug 17, 2010 8:41 AM
          • 3. Re: Illegal combination of non-alphanumeric characters
            747821
            actualli i want to give a parameter for user thru oracle apps

            who insert the path of file ...

            but it gives me error illegal..

            i enter a specific path in the control file but it doesnot resolve yet
            • 4. Re: Illegal combination of non-alphanumeric characters
              706888
              If the location or the filename is changing, maybe your should try to launch sql*loader with the data file as a parameter, have you tried to use the following syntax?:

              under windows
              sqlldr username/password DATA=%1 CONTROL=yourcontrolfile.ctl 
              or (unix systems):
              sqlldr username/password DATA=&1 CONTROL=yourcontrolfile.ctl 
              (and remove the infile parameter from you control file?)

              or replace the parameter (%1 or &1) with the value given by the user.

              Edited by: user11268895 on Aug 17, 2010 8:52 AM
              • 5. Re: Illegal combination of non-alphanumeric characters
                737905
                Are you using sqlloader executable from front end?
                If you are passing the infile as a parameter then make sure you pass the proper path of the infile
                • 6. Re: Illegal combination of non-alphanumeric characters
                  747821
                  @AP
                  yes i'm usgin sql loader from front end

                  i'm using

                  inline '%1' also but it gives me error

                  @AP
                  i give the rite path but the error doesnot go
                  • 7. Re: Illegal combination of non-alphanumeric characters
                    706888
                    You probably mean "infile %1"
                    if it's the case that normal you have the error: The CTL file is not a command file:
                    You must invoke sqlloader with the parameter DATA=%1 and CONTROL=yourcontrolefilename.CTL from the shell. (but remove the infile=%1 inside your CTL file

                    Look my previous post.

                    Edited by: user11268895 on Aug 17, 2010 9:22 AM
                    • 8. Re: Illegal combination of non-alphanumeric characters
                      737905
                      %1 not required. You can just give infile * as you did before.

                      Firstly,

                      Give the complete path in the ctl file itself, remove the parameter from the concurrent program and try invoking the sql loader concurrent program and check if that works.
                      If it does, then mention the parameter in the concurrent program again, and in the CTL file just say infile * and test again.
                      • 9. Re: Illegal combination of non-alphanumeric characters
                        747821
                        @AP
                        i dont it both but it gives me error

                        if i'm using standard sqlloader function .. and it works fine ..

                        but my text file read from the database server not my PC [client] [standard sql loader]

                        My Log File is
                        thru folder share
                        Arguments
                        ------------
                        
                        \\\\\\192.168.200.159\\test\\test.txt
                        ------------
                        SQL*Loader-500: Unable to open file (\\192.168.200.159\test\test.txt)
                        SQL*Loader-553: file not found
                        SQL*Loader-509: System error: No such file or directory
                        SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
                        thru without folder share
                        Arguments
                        ------------
                        c:\\test\\test.txt
                        ------------
                        SQL*Loader-500: Unable to open file (c:\test\test.txt)
                        SQL*Loader-553: file not found
                        SQL*Loader-509: System error: No such file or directory
                        SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
                        but if path define on database then it works
                        oradb02/oracle/PROD/apps/apps_st/appl/gl/12.0.0/bin/test.txt
                        ------------
                        
                        SQL*Loader: Release 10.1.0.5.0 - Production on Tue Aug 17 17:17:48 2010
                        
                        Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                        
                        Control File:   /oradb02/oracle/PROD/apps/apps_st/appl/ap/12.0.0/bin/apxdiner.ctl
                        Data File:      /oradb02/oracle/PROD/apps/apps_st/appl/gl/12.0.0/bin/test.txt
                          Bad File:     /oradb02/oracle/PROD/inst/apps/PROD_db02/logs/appl/conc/out/o1124273.out
                          Discard File: /oradb02/oracle/PROD/inst/apps/PROD_db02/logs/appl/conc/out/o1124273.out 
                         (Allow all discards)
                        my first problem is different to this problem

                        plzz help me in both the questions
                        • 10. Re: Illegal combination of non-alphanumeric characters
                          737905
                          Yes the data file should be placed in the database server.

                          If you mention the complete path "/oradb02/oracle/PROD/apps/apps_st/appl/gl/12.0.0/bin/test.txt" in the ctl file ,and run the concurrent program, does that work?
                          • 11. Re: Illegal combination of non-alphanumeric characters
                            747821
                            if i'm running my sql loader funtion and
                            gives the path of my drive then it gives me error
                            error log is
                            Arguments
                            ------------
                            C:\\test\\test.txt
                            ------------
                            SQL*Loader-350: Syntax error at line 1.
                            Illegal combination of non-alphanumeric characters
                            {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 
                            • 12. Re: Illegal combination of non-alphanumeric characters
                              706888
                              the conventions used to describe the path are not the same:

                              1st: on unix (or uniy like) systems you use "/" (slash)between folders while under windows systems you use "\" (backslash)...

                              2nd: in the error message i see the "{" character (accolade) does this character is really part of your path? ..

                              Edited by: user11268895 on Aug 17, 2010 9:42 AM
                              • 13. Re: Illegal combination of non-alphanumeric characters
                                737905
                                Please, dont pass the path of your local drive.

                                I would like you to change the ctl file with the statement:

                                infile /oradb02/oracle/PROD/apps/apps_st/appl/gl/12.0.0/bin/test.txt

                                save the ctl file and ftp it back to the server. Then remove the data_file path parameter in the concurrent program, then run the concurrent program and check if it worked.

                                Also make sure the file test.txt exist in the path "/oradb02/oracle/PROD/apps/apps_st/appl/gl/12.0.0/bin

                                Edited by: AP on Aug 17, 2010 12:41 AM
                                • 14. Re: Illegal combination of non-alphanumeric characters
                                  747821
                                  @Ap
                                  can i read text file from my PC

                                  becoz i have access oracle application on my pc
                                  and i create a text file and saved it into my local drive "D"
                                  can i read from there? or read only database server i.e \oraapp02.....
                                  1 2 Previous Next