Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

re: Sql string parameter

Rao MSep 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
122 views