ERPstuff - Oracle EBS Community

"inival" column is Long type. I wan to set this value
{'XYZ','\\\\pqr\\uvw\\'}

I was trying this SQL

update table_abc
set inival = '{'XYZ','\\\\pqr\\uvw\\'}'
where inisection = 'V.L'


and the error was



set inival = '{'XYZ','\\\\pqr\\uvw\\'}'
*
ERROR at line 2:
ORA-00933: SQL command not properly ended


and if used set inival = "{ }"

then error is

set inival = "{'XYZ','\\\\pqr\\uvw\\'}"
*
ERROR at line 2:
ORA-00972: identifier is too long


Can anyone help?

hi,

try this query

update table_abc
set inival = '{"XYZ","\\\\pqr\\uvw\\"}'
where inisection = 'V.L'

Thanks
Mohan