Page 1 of 1

Exception in ODAC 5.80.0.40 "ORA-01007: variable not in select list"

Posted: Tue 06 Mar 2007 15:26
by Leonid
We are using last ODAC release OraDirect 5.80.0.40 with Delphi 7 and Oracle 10g.
I am using stored procedure that returns cursor with different number of columns according to the input parameter. In Delphi application I am adding and removing unnecessary OraStoredProc fields dynamically.
When first call of stored procedure return all fileds but second call return only part of the fields and unnecessary fields in Delphi application was removed an exception described above occurs.
This feature works well on ODAC version 5.55.0.0
We are waiting fix of this bug ASAP.
Small example and DB objects script was send to support mail.

Regards Leonid

Posted: Wed 07 Mar 2007 08:23
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.

Posted: Wed 07 Mar 2007 09:07
by Leonid
Do you have any information when next release will be published? This issue is very urgent for us.

Posted: Wed 07 Mar 2007 09:31
by Plash
We are planning to release new ODAC build with the fix in two weeks. If this problem is critical for you, please contact us by e-mail odac*crlab*com and specify your licence number, ODAC edition and Delphi version.