Analytics Software

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!

Scape a single quote in SQL statement prompt code

Alex1Jul 23 2014 — edited Jul 30 2014

Hi experts!

I'm using obiee 11.1.1.7 and I have a problem doing a SQL Statement using prompts.

I have a member of my dimension that contains single quote like: L'Oreal and my prompt doesn't work propertly.

in sql statement I have this code:

SELECT "Dim_Product"."Description" FROM "Products" WHERE "Dim_Product"."Name" = CASE WHEN length('@{pv_name}')=0 THEN "Dim_Product"."Name" ELSE '@{pv_name}' END)

I think that I have to add something like encode in my presentation variable but I don't know how --> '@{pv_name}'

Any help???

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2014

Added on Jul 23 2014

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

10 comments

1,413 views