Post reply

SP call in Data Driven Subscription

  • November 10, 2008 at 8:04 pm

    #201087

    Hi,

    How to call Oracle SP in query window of Data Driven subscription

    SP works fine in Oracle but in RS gives following error

    The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery)

    I m calling SP as

    exec spname

    thanks

  • November 11, 2008 at 8:45 am

    #896993

    I dont think it works in that way. U need to write actual query.

    Basically you need to retrieve recepient list in that query.

    So something like:

    Select email_address, table_field from yourtable where table_field = @parameter

    Here u need to send detail to particular data (table_field) from the database to email_address retrieved in the query.

    Thats how data driven subscription works.

    Regards,

    Vijay

  • November 11, 2008 at 5:48 pm

    #897240

    thanks but when i write following query in data driven subscription it gives error

    Select email_address, table_field from yourtable where table_field = @parameter

    where parameter is a report parameter.

    The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery)

    If i replace above query with following syntax

    Select email_address, table_field from yourtable where table_field = :parameter

    It gives error at time of report generation (timed subscription)

    ORA ---- : All variables not bound.

    I need to know the correct syntax of using report parameter in data driven subscription query.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply