PL/SQL (MOSC)

MOSC Banner

Selecting from table with a string that contains a resevered word.

edited Oct 1, 2013 4:36AM in PL/SQL (MOSC) 7 commentsAnswered
Hi,

I am trying to select a table column, however this particular value contains a reseved word (local). I have tried using \ within the string to mask out the resevered word however this doesn't work. This was within sqlplus. I have also tried this in PL/SQL :-

SET SERVEROUTPUT ON size 1000000

DECLARE

V_PARAM  VARCHAR2(2000);
V_PHASE  VARCHAR2(2);

BEGIN

V_PHASE := '92';
V_PARAM := 'SERVICE_WSDL_URL=http://hypappcp008.live.<mydomain>.local/PSIGW/PeopleSoftServiceListeningConnector/RC_EBS_LOCATION_INC_SERV
ICE.1.wsdl SERVICE_NAME=RC_EBS_LOCATION_INC_SERVICE SERVICE_PORT=RC_EBS_LOCATION_INC_SERVICE_Port SERVICE_PORTTYPE=RC_EBS_LOCATION_

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