<div>
- use doublequote to wrap the lowercase columnnames eg:<br />
<br />
SELECT &quot;description&quot;, &quot;title&quot; FROM tablename
</div>


- use doublequote to wrap the lowercase columnnames eg:

SELECT "description", "title" FROM tablename

<div>
Can you give the full trigger code here to review ?
</div>


Can you give the full trigger code here to review ?

<div>
<div class="content wysiwyg-content">
I am creating a trigger for a table<br />
<br />
where in the columns are in lower case like <br />
description<br />
title<br />
even when I refer as :new.description or :new.title<br />
<b>I am getting error bad bind variable. </b><br />
How to refer these in triggers.<br />
<br />
Also, Is it possible to get new or old blob columns in a trigger.<br />
<br />
Thanks,<br />
Sakthi.<br />
<br />
<br />
<br />
<br />

</div>
</div>


I am creating a trigger for a table

where in the columns are in lower case like 
description
title
even when I refer as :new.description or :new.title
I am getting error bad bind variable. 
How to refer these in triggers.

Also, Is it possible to get new or old blob columns in a trigger.

Thanks,
Sakthi.






How to refer columns with lower case, columns of blob/clob datatype in a trigger?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.