Forum Stats

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

Discussions

Can OBIEE use Bind Variables?

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:

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
  • 649461
    649461 Member Posts: 15
    I checked with Oracle support and it is official - OBIEE does not support bind variables.
  • 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
This discussion has been closed.