Forum Stats

  • 3,824,871 Users
  • 2,260,434 Discussions
  • 7,896,332 Comments

Discussions

substitution strings in select-statemtens

2»

Answers

  • flavioc
    flavioc Member Posts: 1,128 Silver Badge
    Christian,
    well, after you last comment my understanding is that you want to "route" the queries dynamically depending on the value of an application item or something like that.
    My initial understanding was that you perhaps wanted a more static type of routing, that is why i suggested to use different workspaces for binding the desired schema, where you could place synonyms hiding the db links.

    If you want to achieve truly dynamic routing, then may be you should use the "parse SQL at run-time only" option, may be that can do the trick, but i do not guarantee that you won't get stuck somewhere else along the path.

    Bye,
    Flavio

    ----------------------------------------
    http://www.oraclequirks.com
  • i try it now with two apex workspaces. one for test and one for production. then i can use the same db-link name for test and production, but they link to different databases...

    thx for your help!

    bye,
    christian
This discussion has been closed.