DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01006 Bind variable does not exist

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Unhappy

    Hi guys,

    Oracle 8.1.7.3.0/ NT.

    We are getting 'ORA-01006 Bind variable does not exist' msg from Report designer when we run foll. query.

    select unique r.trx_number
    from ra_customer_trx_all r, gl_sets_of_books g, ar_system_parameters_all a
    where a.set_of_books_id = g.set_of_books_id
    and a.org_id = r.org_id
    and g.short_name = 'EDU'

    I had set CURSOR_SHARING to FORCE at this time. After that, I set it to its default and the error was gone.

    Does anybody know if there is any bug with this init parameter and is there any solution to this?

    Thanks in Adv.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Guys,

    Waiting for some reply...

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Red face


    Any taker for this thread?
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Nov 2005
    Posts
    32
    hi
    which version of form u r using form 5 does not support cursor_sharing other then EXACT ,we have just faced this problem we changed cursor_sharing from exact to similar and this problem start occuring ,now we changed the parameter to exact now it is working

    hope it isnt too late

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    CURSOR_SHARING=FORCE might cause a lot of side effects.
    You may frequently see Ora-600 error also

    Do not use it.

    Tamil

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