PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Single quotes appearing in a SQL for a string value

Hello,

Need help in resolving this issue,

I am assigning String variable to a State record character field in a people code and using same field in a SQL but whenever this field is resolved in SQL it comes with single quotes which makes my SQL incorrect. Any idea how can i fix it, i tried noquotes for bind variable but did not work.

in People Code

C_INT_APP_AET.PAGETEXT1.Value = &fieldVar;

in SQL

(%Bind(PAGETEXT2, NOQUOTES)) this expands into a character value with Quotes around it.

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