# Using the \<ora:createtrigger ...../\> using the liquibase-oracle-1.2.0.jar .

**URL:** <https://forum.liquibase.org/t/using-the-ora-createtrigger-using-the-liquibase-oracle-1-2-0-jar/1541>\
**Category:** General Discussion\
**Created:** [June 30, 2011, 8:12pm UTC](https://forum.liquibase.org/t/using-the-ora-createtrigger-using-the-liquibase-oracle-1-2-0-jar/1541 "2011-06-30T20:12:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [June 30, 2011, 8:12pm UTC](https://forum.liquibase.org/t/using-the-ora-createtrigger-using-the-liquibase-oracle-1-2-0-jar/1541/1 "2011-06-30T20:12:00Z")

</div>

Hi,   
I was trying to migrate a Sample.xml file which contains a table and a ora:createtrigger.../ tag using the&nbsp; liquibase-oracle-1.2.0.jar (provided in the oracle extensions) in the classpath. My Sample file is as follows:  
  
\<?xml version="1.0" encoding="UTF-8"?\>  
  
&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp; \<ora:createTrigger  
&nbsp;&nbsp;&nbsp; afterBeforeInsteadOf=“before”  
&nbsp;&nbsp;&nbsp; procedure=“DECLARE v\_username varchar2(10); BEGIN SELECT pierwsza INTO v\_username FROM TriggerTest;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :new.created\_by := v\_username; END;”  
&nbsp;&nbsp;&nbsp; triggerName=“myTrigger”  
&nbsp;&nbsp;&nbsp; tableName=“TriggerTest”  
&nbsp;&nbsp;&nbsp; insert=“true”  
&nbsp;&nbsp;&nbsp; forEachRow=“true”/\>  
&nbsp;&nbsp;&nbsp;   
  
  
  
When i executed the same from Commandline using the command:   
liquibase --classpath=“ojdbc6.jar;liquibase-oracle-1.2.0.jar” --driver=oracle.jdbc.OracleDriver --changeLogFile=Sample.xml --url=“jdbc:oracle:thin:@localhost:1521:XE” --username=demo2 --password=demo2 migrate  
  
I am getting an error stating :  
INFO 6/30/11 5:38 PM:liquibase: Successfully acquired change log lock  
SEVERE 6/30/11 5:38 PM:liquibase: The prefix “ora” for element “ora:createTrigger” is not bound.  
INFO 6/30/11 5:38 PM:liquibase: Successfully released change log lock  
Liquibase Update Failed: The prefix “ora” for element “ora:createTrigger” is not bound.  
SEVERE 6/30/11 5:38 PM:liquibase: The prefix “ora” for element “ora:createTrigger” is not bound.  
liquibase.exception.ChangeLogParseException: Error parsing line 11 column 24 of Sample.xml: The prefix “ora” for element “ora:createTrigger” is not bound.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.parser.core.xml.XMLChangeLogSAXParser.parse(XMLChangeLogSAXParser.java:106)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:106)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.integration.commandline.Main.doMigration(Main.java:684)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.integration.commandline.Main.main(Main.java:116)  
Caused by: org.xml.sax.SAXParseException: The prefix “ora” for element “ora:createTrigger” is not bound.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.parser.core.xml.XMLChangeLogSAXParser.parse(XMLChangeLogSAXParser.java:98)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 3 more  
  
Can anyone please help me to understand&nbsp; where am I going wrong ??  
I am not able to figure it out…  
Please help.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [June 30, 2011, 8:12pm UTC](https://forum.liquibase.org/t/using-the-ora-createtrigger-using-the-liquibase-oracle-1-2-0-jar/1541/2 "2011-06-30T20:12:00Z")

</div>

Hi All ,  
  
Could you please suggest any update on this?  
  
Regards,  
Hilda

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [June 30, 2011, 8:12pm UTC](https://forum.liquibase.org/t/using-the-ora-createtrigger-using-the-liquibase-oracle-1-2-0-jar/1541/3 "2011-06-30T20:12:00Z")

</div>

Hi All ,  
  
I’m using [liquibase-2.0.1-bin.zip](http://liquibase.org/liquibase-2.0.1-bin.zip "http://liquibase.org/liquibase-2.0.1-bin.zip") version of LiquiBase in my Windows XP environment.   
I found the liquibase-oracle-1.2.0.jar on the following link:   
\<span --driver=oracle.jdbc.OracleDriver --changeLogFile=Sample.xml --url=“jdbc:oracle:thin:@localhost:1521:XE” --username=demo2 --password=demo2 migrate  
  
But I am getting an error :   
The prefix “ora” for element “ora:createTrigger” is not bound.

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [June 30, 2011, 8:12pm UTC](https://forum.liquibase.org/t/using-the-ora-createtrigger-using-the-liquibase-oracle-1-2-0-jar/1541/4 "2011-06-30T20:12:00Z")

</div>

Are you adding the XML namespace&nbsp;

Nathan