0
Good morning. I have a problem/doubt: Why is it not possible to use TO_CHAR more than once for the same field? And why does this influence the outcome of other fields? If someone can explain it to me, thank you. :)
Example 1:
Example 2:
0No answers
Browser other questions tagged oracle sqldeveloper
You are not signed in. Login or sign up in order to post.
Why does "to_char" for a field that is already "string", you want to convert to "tolerance"? to_char is for formatting numbers and dates, see https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34570
– Motta
The column is not string, it’s a CLOB, and I want to make different concatenations with it.
– Gustavo Souza da Rosa
clob !! Putz ! tried DBMS_LOB ? https://docs.oracle.com/database/121/ARPLS/d_lob.htm#Arpls66748see also this example sending email https://oracle-base.com/articles/misc/email-from-oracle-plsql
– Motta
So I tried, what happens, a TO_CHAR works, a DBMS_LOB works, one of each also works, however, any two that I use for the second time in the same column, Leave another column that has nothing to do with the one that I convert with TO_CHAR/DBMS_LOB, values are zeroed as you can see in the print. (the other column is a BINARY_DOUBLE) .
– Gustavo Souza da Rosa
Post the Oracle error in the topic. Does the Oracle error signal this ? Columns Blobs have many restrictions (almost to the point of not using them <laughs>) , here where ERP used a LONG RAW (discontinued) and some columns ,what I did was a FUNCTION that receives the line key and there it treats the "blob" returning the string.
– Motta
I created: https://community.oracle.com/message/15634849#15634849
– Gustavo Souza da Rosa
Don’t you want to give me the job so I can see if the problem would continue? If you don’t want to be cool, I know it’s your personal job. My email: [email protected] . Thank you very much.
– Gustavo Souza da Rosa
I gave it to you without details because it’s company material.
– Motta