Core Concurrent Processing - EBS (MOSC)

MOSC Banner

sql concurrent program

Hi,

Concurrent program type sql.

It has one parameter  text.

In the sql script.

var := '&1';

some time the paramter can have  ' ( quote).

Need 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center