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.
06-13-2002, 09:54 AM
Waiting for some reply...
06-14-2002, 02:44 PM
Any taker for this thread?
12-26-2006, 01:34 AM
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
12-26-2006, 10:55 AM
CURSOR_SHARING=FORCE might cause a lot of side effects.
You may frequently see Ora-600 error also