# Ora-01483 exception in update clob field

**URL:** https://discourse.hibernate.org/t/ora-01483-exception-in-update-clob-field/7251
**Category:** Hibernate ORM
**Created:** [February 12, 2023, 11:17am UTC](https://discourse.hibernate.org/t/ora-01483-exception-in-update-clob-field/7251 "2023-02-12T11:17:51Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![saba\_safavi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/saba_safavi/32/2256_2.png) [@saba\_safavi](https://discourse.hibernate.org/u/saba_safavi)
#### Post date: [February 12, 2023, 11:17am UTC](https://discourse.hibernate.org/t/ora-01483-exception-in-update-clob-field/7251/1 "2023-02-12T11:17:51Z")

</div>

I am trying to update the entity we don’t have any change or update in the code this error occurred in `session.flush()` for updating. here is hibernate update query :  
`update tableName set business.id=:bizId, name=:name, post.id=:post, version=:version_1 ,content=:content where id=:id and version=:version_2`  
and this error occurred :  
`ORA-01483: invalid length for DATE or NUMBER bind variable`  
but when I write SQL query or run query in SQL developer no error occurred.  
I change hibernate query to below and also worked fine without error :  
`update tableName set business.id=:bizId, name=:name, post.id=:post, content=:content, version=:version_1 where id=:id and version=:version_2`  
is there any problem ? how can I fix it !  
here is pom.xml related to hibernate and oracle

```auto
<dependency>
            <groupId>oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.3</version>
        </dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>4.3.6.Final</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-ehcache -->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-ehcache</artifactId>
            <version>4.3.6.Final</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-c3p0 -->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-c3p0</artifactId>
            <version>4.3.6.Final</version>
        </dependency>

```

---

<div class="post-metadata">

### Author: ![beikov](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/beikov/32/258_2.png) [@beikov](https://discourse.hibernate.org/u/beikov)
#### Post date: [February 13, 2023, 10:56am UTC](https://discourse.hibernate.org/t/ora-01483-exception-in-update-clob-field/7251/2 "2023-02-13T10:56:43Z")

</div>

Hibernate 4.3 is not maintained anymore, so I don’t think anyone can help you. Try updating to at least version 5.6.  
Also, to further help you, we need to see the code that you use to execute this query and also the full stack trace.