tag:blogger.com,1999:blog-7230948883808802676.post4050750680089348357..comments2024-03-28T09:47:32.097+05:00Comments on oracleared.blogspot.com - Oracle at My Best: ORA-00932: inconsistent datatypes: expected - got CLOBHaseeb Sanahttp://www.blogger.com/profile/17902435106347421580noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-7230948883808802676.post-21667515356060183092018-01-18T00:20:15.334+05:002018-01-18T00:20:15.334+05:00Super It dbms_lob.substr worked for me Super It dbms_lob.substr worked for me pepallavamsihttps://www.blogger.com/profile/05542259467650969298noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-15366491978981830992016-06-06T11:57:40.974+05:002016-06-06T11:57:40.974+05:00faced same issue after upgrade to 11g from 10g.
E...faced same issue after upgrade to 11g from 10g. <br />Error Message: ORA-00932: inconsistent datatypes: expected - got CLOB<br /><br />modified column size from varcha2(255) to varchar2(300) and it worked.Anonymoushttps://www.blogger.com/profile/14341075708098831732noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-60059486445429362292014-05-07T12:09:43.656+05:002014-05-07T12:09:43.656+05:00i use TO_CHAR instead of SUBSTRi use TO_CHAR instead of SUBSTRAnonymoushttps://www.blogger.com/profile/06209062129168131779noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-27200815300016481072014-04-22T19:55:36.891+05:002014-04-22T19:55:36.891+05:00Thanks you very much
Thanks you very much<br />veenahttps://www.blogger.com/profile/13950656478008050221noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-76501949081519687662013-12-16T14:15:47.263+05:002013-12-16T14:15:47.263+05:00Thank you so much....it helped !!! :)Thank you so much....it helped !!! :)Anonymoushttps://www.blogger.com/profile/00737450529388545125noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-11568819198096589762013-05-22T22:31:22.219+05:002013-05-22T22:31:22.219+05:00select distinct o.id "Organization ID",
...select distinct o.id "Organization ID",<br /> en.entity_id "Contact ID",<br /> en.entity_cd "Note Entity Code",<br /> ed.entity_name "Note Entity",<br /> en.entity_id "Note Entity_id",<br /> en.note_dt "Note Date",<br /> en.create_dt "Create Date",<br /> en.update_dt "Update Date",<br /> FN_LOCALIZE_BI(nt.desc_id, 'EN', 'default') "Type",<br /> en.subject "Subject",<br /> replace(replace(dbms_lob.substr(en.description, 4000, 1),<br /> chr(10),<br /> '\n'),<br /> chr(13),<br /> '\n') "Content"<br /> from entity_notes en<br /> left join note_type nt<br /> on nt.type_cd = en.note_type<br /> left join entity_definition ed<br /> on en.entity_cd = ed.entity_cd<br />inner join contact_owner co<br /> on co.contact_id = en.entity_id<br />inner join organization o<br /> on o.id = co.organization_id<br />where (en.sync_src_cd = 'MANUAL' or en.sync_src_cd is null)<br /><br />this is the original query<br /><br />with this query client is getting only 4000 characters for the description column.<br /><br />They need almost to 32000 characters for the description column with the same query and logic<br />Any way this can be achieved?<br /><br /> <br />Pavam Kootukaranhttps://www.blogger.com/profile/01261726557112241129noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-421458247472810392013-02-11T21:30:21.291+05:002013-02-11T21:30:21.291+05:00You are Welcome Dear.You are Welcome Dear.Haseeb Sanahttps://www.blogger.com/profile/17902435106347421580noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-20844430969734291542013-02-11T20:43:41.190+05:002013-02-11T20:43:41.190+05:00I got this issue while using comment field in unio...I got this issue while using comment field in union, used dbms_lob.substr and this helped. Thank you..AmitAnonymoushttps://www.blogger.com/profile/06668671255095337292noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-90175558787907786132012-09-27T23:49:34.112+05:002012-09-27T23:49:34.112+05:00Dear Ritesh,
I have tried following query and it w...Dear Ritesh,<br />I have tried following query and it worked fine,<br /><br />select dbms_lob.substr(ADDRESS_TEXT) a,<br /> dbms_lob.substr(ADDRESS_TEXT,1,10) b<br /> from HZ_CUST_ACCT_SITES_ALL<br /><br />RegardsHaseeb Sanahttps://www.blogger.com/profile/17902435106347421580noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-26224941165214348252012-09-27T22:04:02.397+05:002012-09-27T22:04:02.397+05:00But the dbms_log.substr(<>,[startindex],[num...But the dbms_log.substr(<>,[startindex],[numberofchar]) doesn't work in this case. Have anyone tried this ?<br /><br />Thanks RiteshRiteshhttps://www.blogger.com/profile/15806278520422019880noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-3608804781558294572012-09-16T11:49:17.611+05:002012-09-16T11:49:17.611+05:00Welcome :)Welcome :)Haseeb Sanahttps://www.blogger.com/profile/17902435106347421580noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-76687852592061571692012-09-15T06:00:16.685+05:002012-09-15T06:00:16.685+05:00I got into this scenario when concatenating multip...I got into this scenario when concatenating multiple records in one col to a single cell value. I got struck and searching for solution. I applied your solution and it worked!!!.<br />Thank you very much!!!<br />Manickalalkrmhttps://www.blogger.com/profile/12703129233629431110noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-8402925517784504452012-07-19T10:36:03.552+05:002012-07-19T10:36:03.552+05:00Have you tried this dbms_lob.substr()?Have you tried this dbms_lob.substr()?Haseeb Sanahttps://www.blogger.com/profile/17902435106347421580noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-69442459158189380862012-07-12T00:38:51.915+05:002012-07-12T00:38:51.915+05:00I have the same problem but with OWB 11g while try...I have the same problem but with OWB 11g while trying to import data from a SQL Server to an Oracle database. The mapping which makes migrating data possible returns this error fact that makes it impossible to fill the oracle table with data. Do you have any idea about what I should do?Stiri mobilehttps://www.blogger.com/profile/09719024404279197065noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-6834422641221761582012-06-19T11:08:46.694+05:002012-06-19T11:08:46.694+05:00You are always welcome.
Looking forward for your s...You are always welcome.<br />Looking forward for your suggestions.Haseeb Sanahttps://www.blogger.com/profile/17902435106347421580noreply@blogger.comtag:blogger.com,1999:blog-7230948883808802676.post-26374472826392061732012-06-18T21:22:06.174+05:002012-06-18T21:22:06.174+05:00Thank you! This helped me with trying to figure ou...Thank you! This helped me with trying to figure out how I was getting this error and what to do to get around it. Well, now that I have this, I'm another step along the journey! <br /><br />Thanks for this!Tony Dunsworthhttps://www.blogger.com/profile/02804983768242766173noreply@blogger.com