The processing instruction target matching "[xX][mM][lL]" is not allowed.

General Discussion
1

Here’s a couple links about JDBC escapes that might help

JDBC escapes
Escape syntax

I have heard these mentioned but never personally worked with them.

Hope this helps!

2

This is an XML issue - you can’t have the ‘<’ and ‘>’ characters inside the tags.

Try replacing the characters with the entity  < and >

XmlHeader varchar2(100) := ‘<?xml version = “1.0” encoding = “#1”?>’ || chr(10);

3

We have a problem with a stored procedure ( oracle )


<databaseChangeLog

    xmlns=“http://www.liquibase.org/xml/ns/dbchangelog”

    xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

    xmlns:ext=“http://www.liquibase.org/xml/ns/dbchangelog-ext”

    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd

    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">



    CREATE OR REPLACE PROCEDURE testHello

    IS

      XmlHeader varchar2(100) := ‘<?xml version = "1.0" encoding = "#1"?>’ || chr(10);

    BEGIN

      DBMS_OUTPUT.PUT_LINE(‘Hello From The Database!’);

    END;

4

Thank you


I have another error “Not supported SQL92-Token in Position: 6731: Record”


The Problem are the character { } , how do i mask them


/*******************************************************************************

  • copyright © 2004 by MIC           projekt: CUST

********************************************************************************/

/**

*

  • split record into individual fields; the following syntax will be

  •              used:

  •              Record := Field { , Field } CR

  •              File := { Record }

  •              Field := Text | " Text " | Number

  •              Text := any character

  •              Number := { 0-9 } [ . { 0-9 }

*

  •              if the field sperator ‘,’ is used within a Text, then the complete

  •              field has to be enclosed by ‘"’; if this escape character is used

  •              within a Text, then it also has to be enclosed by ‘"’ and the ‘"’ in

  •              Text is to be dobled to ‘""’


  • @paras rsRecord   next record of CLOB in MIC_EDI_FILE

  • @paras rbErrcode  TRUE if exception occured

  • @paras rsErrtext  Errortext

  • @return TRUE if record was found, FALSE else and if exception

  •         occurs (rbErrcode is TRUE in this case)

*/

5

CDATA doesn’t help, i think this a JDBC Problem

6

Problem is solved with the newest oracle jdbc driver ( 11.2.0.3)

7

Check out this forum entry (http://forum.liquibase.org/topic/cannot-create-stored-procedures-in-sql-server) for a clue.

Maybe you can use the CDATA method for handling the XML and problem characters.