September 17, 2013 at 8:10 pm
Hi All,
I have spent few hours looking into the issue and still cannot figure this one out.
I have created parameter @OrgNumber which I am getting the available values from View(Oracle - connected via OLEDB) and passing it to query to generate report but it returns empty result. Below is i am using ..
SELECT CHANNEL_ID, CHANNEL_CODE, ORGNO, TEAM_CODE, CHANNEL_NAME, CHANNEL_GRADE, CHANNEL_TYPE, CHANNEL_TYPE_NAME, PARENT_ID, STATUS,
LEADER_ID, LEADER_THAI_FULL_NAME, ACNT_ORG_YN, CHANNEL_GRADE_NAME, ZIP, HOUSE_NO, VILLAGE, MOO, SOI, STREET, SUBDISTRICT, DISTRICT, CITY,
TELEPHONE, INSERTED_BY, INSERT_TIME, UPDATED_BY, UPDATE_TIME
FROM DEV_DATAHUB.DH_V_ISTRUCTURE
WHERE (ORGNO = ('@OrgNumber'))
My question is when I insert the parameter it has single quotes wrapped around parameter name. From Oracle the data type is VARCHAR and I am setting value type as tect in ssrs. ANy suggestions? please help.
Thanks,
J
September 18, 2013 at 1:43 pm
You need to get rid of the single-quotes and replace the @ with a :. Check out this blog post
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 19, 2013 at 5:00 am
Jack is correct, for Oracle you need a colon : for parameters.
January 15, 2014 at 2:53 pm
Hi
This link looks useful, but unfortunatly it suggests using '+' as a concatination, which Oracle doesn't support, and it has the parameter without single quotes which oracle expects to be an object name not a literal string so basically it doesn't work 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply