File Content Loading to Oracle Error

Shell Programming and Scripting
1

I habe a UNIX Variablw with content as below:

 WHOLE_REC_TXT="$record"

where $record contains contents of file

Sample contents of file:

topic_id|1624|AIDS-HIV||
topic_id|1625|Allergies||
topic_id|1626|Alzheimer s||
topic_id|1627|Knee Pain||
topic_id|1628|Autism||
topic_id|1629|Atrial Fibrillation||
topic_id|1630|Acne Care||
topic_id|1632|Urinary Tract Infection||
topic_id|1633|Children's Vaccines||
topic_id|1634|HPV / Genital Warts||

i want to load the WHOLE_REC_TXT to a column in oracle table.
But it throws me error:

ERROR:
ORA-01756: quoted string not properly terminated

Let me know if i am doing something worng.

2

Please show your code.

3

The problem is most likely the single quote in this line (hard to say without seeing your code):

topic_id|1633|Children's Vaccines||

Use two single quotes to insert a single quote when working with string literals:

topic_id|1633|Children''s Vaccines||