SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inconsistent datatypes: expected NUMBER got LONG

Shadow123Oct 23 2015 — edited Oct 24 2015

Version 3.2.20.09

I'm using SQL Developer and want to see trigger body by using like function but unfortunately its data type is long so that I'm getting error, is there any way through which I can see trigger body....

Sample query

TRIGGER_BODY

SELECT TRIGGER_BODY FROM user_triggers

WHERE TRIGGER_BODY LIKE '%HEAR';

Error

ORA-00932: inconsistent datatypes: expected NUMBER got LONG

00932. 00000 - "inconsistent datatypes: expected %s got %s"

*Cause:

*Action:

Error at Line: 2 Column: 7

This post has been answered by Gary Graham-Oracle on Oct 23 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2015

Added on Oct 23 2015

#sql-developer

6 comments

873 views