1 Reply Latest reply on Jun 5, 2018 8:35 AM by Aryan Anantwar

    ORA-00911: Invalid character

    Exequiel Carballeda

      Hello! I need do an oracle query. I use ro-adapter-sql-actor with oracle.jdbc.driver.OracleDriver. The problem is that my query use ";" but this is an invalid character to BAO. How can i solve this problem?

       

      <request-data>

        <sqlAdapterRequest>

          <targets>

            <target name="">

              <user-name>user</user-name>

              <password>****MASKED****</password>

              <driver>oracle.jdbc.driver.OracleDriver</driver>

              <url>jdbc:oracle:thin:@//hostname:1521/apexdesa</url>

            </target>

          </targets>

          <action>INSERT INTO usr_inventario.aplicacion( APLICACION_ID,APLICACION_NAME,RESPONSABLE1,RESPONSABLE2,SECTOR,COMENTARIO)

      values ( usr_inventario.seq_aplicacion.nextval , 'PRUEBA', 'PRUEBA', 'PRUEBA', 'PRUEBA', 'PRUEBA'); 

      Insert into USR_INVENTARIO.ORA_PDB

         (ORA_PDB_ID, PDB_NAME, PDB_ENCRYPT, ORA_CONTENEDOR_ID, AMBIENTE,CADENA_CONN , PDBADMINPW, APLICACION_ID, ISPROD)

      Values

        ( usr_inventario.seq_ora_pdb_id.nextval,

        'PDBFACUPRUEBA',

         0,

        (select ora_contenedor_id from usr_inventario.ora_contenedor  where ora_contenedor_nombre = 'CDBDEV01'),

        'DESARROLLO',

        '',

        'Nueva123',

        (select aplicacion_id from usr_inventario.aplicacion where aplicacion_name = 'PRUEBA'),

        0

        );

      commit;</action>

        </sqlAdapterRequest>

      </request-data>

       

       

       

       

      <sqlAdapterResponse>

        <metadata>

          <status>success</status>

        </metadata>

        <targets-output>

          <target-output name="//hostname">

            <target-metadata>

              <database-vendor>Oracle</database-vendor>

              <metadata>error</metadata>

              <error>Error occured performing query: Message[summary=Exception in Simple query execution for Adapter ORACLESQL. ORA-00911: carácter no válido

      , detail=Exception in Simple query execution for Adapter ORACLESQL. ORA-00911: carácter no válido

      ]</error>

            </target-metadata>

            <metadata>

              <status>error</status>

              <error>Error occured performing query: Message[summary=Exception in Simple query execution for Adapter ORACLESQL. ORA-00911: carácter no válido

      , detail=Exception in Simple query execution for Adapter ORACLESQL. ORA-00911: carácter no válido

      ]</error>

            </metadata>

          </target-output>

        </targets-output>

      </sqlAdapterResponse>