Skip to Main Content

SQL & PL/SQL

re: Sql string parameter

User_IPZH9Sep 24 2020 — edited Sep 25 2020

Hi,

I have a sql program which accepts 5 parameters. One of them is a text.

Some times it can have ' (quote).

var := '&1';

Trying to replace single quote with double.

How can I do it as program fails on the assignment itself

var := '&1'; 

ORA-01756: quoted string not properly terminated

replace commands also same error.

This is called by many programs. We would like to change in this one program instead of all calling program do the replace.

thanks

This post has been answered by jaramill on Sep 24 2020
Jump to Answer
Comments
Post Details
Added on Sep 24 2020
8 comments
79 views