Passing bind variables from Access and VB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Passing bind variables from Access and VB

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Question Passing bind variables from Access and VB

    Can someone explain(or point me to a page that explains) how the best way to pass bind variables from Access and VB to Oracle. When looking thru my sql statements in the sga i am finding SQL that looks like it is using a bind variable but is parsed 200,000 times and executed 200,000 times, so it doesnt seem to be using it correctly. this is the sql from the sga

    SELECT "SUBMISSION_KEY" ,"DIARY_ENTRY" FROM "PRODUCTION"."CLM_CLAIM_DIARY" WHERE ("SUBMISSION_KEY" = :1 )


    thanks in advance,
    SM

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    i wonder if this is a case where the init parameter cursor_sharing might be set to "forced".

    I know there's a whole bunch of caveats on the use of this parameter, but you might just try ..


    "ALTER SYSTEM SET CURSOR_SHARING=FORCED"

    ... and see if anything good happens.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by slimdave
    i wonder if this is a case where the init parameter cursor_sharing might be set to "forced".

    I know there's a whole bunch of caveats on the use of this parameter, but you might just try ..


    "ALTER SYSTEM SET CURSOR_SHARING=FORCED"

    ... and see if anything good happens.


    its FORCE not FORCED.

    "ALTER SYSTEM SET CURSOR_SHARING=FORCE"

    I assume there were two typo here
    Last edited by adewri; 04-10-2003 at 12:33 PM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    ah yes. i'm more of a concept person than an implementer.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Oct 2000
    Posts
    103
    If i remember correctly that can only be done in 8i release 2, I am on 8.0.5

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Ah, the perfect excuse for an upgrade.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Oct 2000
    Posts
    103
    yeah, i agree, great reason for an upgrade...but its not gonna happen :( anytime soon. So I need to figure out how to use bind variables from clients in VB and access.

    SM

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have a look at metalink note 111845.1 "Using Bind variables with RDO, ODBC in SQL Statements", and also try a search on metalink -- i believe they have some odbc/bind variable examples.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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



Click Here to Expand Forum to Full Width