cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aaedla
Helper V
Helper V

Oracle CLOB column not accepting more than 4000 characters

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

1 REPLY 1
SGRUBIO
New Member

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,292)