Passing parameter from Table View from Oracle returns empty result

  • 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

  • You need to get rid of the single-quotes and replace the @ with a :. Check out this blog post

  • Jack is correct, for Oracle you need a colon : for parameters.

  • 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