Forum Stats

  • 3,837,843 Users
  • 2,262,301 Discussions
  • 7,900,406 Comments

Discussions

Categories

Can OBIEE use Bind Variables?

user646449
user646449 Member Posts: 1
edited Sep 25, 2008 11:49AM in Business Intelligence Suite Enterprise Edition (OBIEE)
I'm doubtful that we'd want to use them for warehouse queries, but I'm being posed the question. Has anyone used them in OBIEE?

[Here is a brief synopsis on them.|http://www.akadia.com/services/ora_bind_variables.html]
Tagged:
· Share on TwitterShare on Facebook

Best Answer

Answers

  • 14728
    14728 Member Posts: 633
    edited Sep 24, 2008 12:37PM
    The SQL generated (you can see for yourself) contains literal values within the predicates.

    That article is fine for OLTP, Datawarehouses are the exception to the rule regarding BIND variable usage.

    Tom Kyte has written a blog on this which I will try to find it and post.


    Couldn't find the actual blog think it was last year some time but this thread explains a lot:

    [Binds in DW|http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:24269876789087]

    Edited by: Matt T on Sep 24, 2008 5:36 PM
    14728
    · Share on TwitterShare on Facebook
  • 649461
    649461 Member Posts: 15
    Answer ✓
    I checked with Oracle support and it is official - OBIEE does not support bind variables.
    · Share on TwitterShare on Facebook
  • 628531
    628531 Member Posts: 1,293
    You can make a workaround, using the connection scripts:
    http://obiee101.blogspot.com/2008/02/obiee-using-oracle-stored-procedures.html

    regards

    John
    http://obiee101.blogspot.com
    · Share on TwitterShare on Facebook
This discussion has been closed.