oracle-enhanced icon indicating copy to clipboard operation
oracle-enhanced copied to clipboard

write_lobs fix: handle table with composite primary key

Open dsusco opened this issue 4 years ago • 1 comments

I ran into this issue trying to update a CLOB attribute in a table with a composite primary key. The SELECT FOR UPDATE statement was just dumping the comma delimited primary key into the where clause:

WHERE 'column_a,column_b' = "I'm in the mood to help you dude..."

I added a check for an array of primary keys, and if found built the id conditions up.

dsusco avatar Jan 05 '21 14:01 dsusco

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Jun 26 '21 03:06 stale[bot]