CODEWITHSUNDEEP
oracle-databaseplsql
Abinnaya
Abinnaya

Reputation: 223

Need to Concatenate " " inside the string of plsql code oracle apex

I have the below XML string inside my PL/SQL block. In the string I need to pass the parameter values, for example: p_username is "admin" (including the double quotes). Right now I am directly passing the value as "admin" but it's not correct. I need to pass only admin (without the double quotes). The double quotes needs to be concatenated inside the string.

Relevant block inside my PL/SQL code:

<urn:Login>
    <!--TrustedId>$tr.ByRb08A8</TrustedId-->
    <urn:UserName>' || p_username ||
                   '</urn:UserName>
    <urn:Password>' || p_password ||
                   '</urn:Password>
</urn:Login>

Upvotes: 0

Views: 334

Answers (1)

Dan McGhan
Dan McGhan

Reputation: 4659

Have you tried this?

<urn:Login>
    <!--TrustedId>$tr.ByRb08A8</TrustedId-->
    <urn:UserName>"' || p_username ||
                  '"</urn:UserName>
    <urn:Password>"' || p_password ||
                  '"</urn:Password>
</urn:Login>

Upvotes: 1

Related Questions