Load Ingest Data
Results 1 to 9 of 9

Thread: Virtual Stored Procedure

  1. #1
    jobrien is offline Junior Member
    Join Date
    Aug 2009
    Posts
    17
    Rep Power
    0

    Virtual Stored Procedure

    Hi there,

    I've created parameterised sql using named parameters and saved it as a virtual stored procedure.

    As far as i can see the order of the parameters for the caller depends on the order they are declared in the sql.

    Is there any way to specify the parameter order (as oracle/sql server does)?

    create procedure xyz (param1 string) as
    select * from...

    this syntax doesn't seem to be supported - this means that i cannot guarantee the stored proc api as it's dependent on the select statement.

    is there any way round this?

    regards,

    jim.

  2. #2
    Boaz Newman is offline Support
    Join Date
    Aug 2006
    Posts
    30
    Rep Power
    0

    Named parameters are not supported

    Hello Jim

    A stored procedure in a virtual data source, supports only a select statement, the parameters are specified in the select statement itself.
    The values for the parameters are supplied by order and not by the parameters names.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    jobrien is offline Junior Member
    Join Date
    Aug 2009
    Posts
    17
    Rep Power
    0

    Parameter Order

    Is there any chance that calling by name can be added to the ado.net provider to keep it in line with sql server/oracle classes?

    It seems to me that virtual stored procedures are only of any use in the real world if the order of parameters can be guaranteed.

    thanks,

    jim.

  4. #4
    Boaz Newman is offline Support
    Join Date
    Aug 2006
    Posts
    30
    Rep Power
    0

    Added to wish list

    Hello Jim

    Your request was added to our wish list for future product enhancement.

    Regards
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    jobrien is offline Junior Member
    Join Date
    Aug 2009
    Posts
    17
    Rep Power
    0

    Named Parameter

    Thanks Boaz,

    Would this feature be likely in the near future - this would be a handy feature in our current development.

    If it was implemented in the same way as SQL Server then we can add parameters using @parm_name now, and they will work as named parameters in the future release.

    regards,

    jim.

  6. #6
    jobrien is offline Junior Member
    Join Date
    Aug 2009
    Posts
    17
    Rep Power
    0

    Named parameters and ADO.NET

    Bump...

    Boaz, is it possible for you to give a view to whether this feature is likely to be included in the near future, or is it a big implementation task that is unlikely to be implemented/take a long time to implement.

    thanks,

    jim.

  7. #7
    jobrien is offline Junior Member
    Join Date
    Aug 2009
    Posts
    17
    Rep Power
    0

    Virtual Stored Procedures

    Any thoughts?

  8. #8
    Tzachi Nissim is offline Product Implementation Director
    Join Date
    Aug 2006
    Posts
    17
    Rep Power
    0
    Hi Jim,

    At your request we did the following:

    1. Consulted with R&D about the effort involved in this enhancement.
    2. Checked with our support and field personnel about other requests for this feature.

    We normally do this process for the enhancements on our list when planning a new version, but since you asked for an assessment of the likelihood of a near future implementation we did this now. Unfortunately the R&D assessment was that the effort involved is large and the field assessment was that there was very little demand for this feature. This makes it unlikely to be implemented in the near future.

    Best regards,
    Tzachi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  9. #9
    jobrien is offline Junior Member
    Join Date
    Aug 2009
    Posts
    17
    Rep Power
    0
    thanks.

    jim.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •