Oracle CLOB column not accepting more than 4000 characters

[aaedla]

Hi,

I developed application and backend is Oracle and there multiple CLOB columns in oracle table. These clob columns are throwing "too long string" error if I enter more than 4000 characters. Is there anyway to resolve this issue from powerapps?

Any help would be greatly appreciated.

Thank you

[SGRUBIO]

Hi @aaedla!

To insert into a clob column you would have to do this:

INSERT INTO table
            (
                        c_clob
            )
            VALUES
            (
                        'to_clob('" \n \n \n<meta http- "< font="">' || to_clob('equiv="Content-Type" content="text/html; charset '))

remembering that in each to_clob() the string must be at most 4000 characters long