question

sudama avatar image
sudama asked

ERROR: ORA-01756: quoted string not properly terminated

declare begin select replace('ByteIN07042017085908650 24 N000000000000000000000000000000000000 00000000072557181108590120170407 0000 00000000 000CO 00000000000 S 000002787570100000012 CO 00000000000000000000000000024026120919 000000000000000000000000 CC CC12206712 00000000email000000000000000000000000000000000000 000000000000 0000000 0000 000000000000 00 0000 0000 ','email',' ') into p1_CCS00MESS_TEMPLATE from dual; dbms_output.put_line(p1_CCS00MESS_TEMPLATE); end; / ERROR: ORA-01756: quoted string not properly terminated
sqlqueryreplace
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.