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

Leonid · Post by **Leonid** » Tue 06 Mar 2007 15:26

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

Plash · Post by **Plash** » Wed 07 Mar 2007 08:23

We have fixed this problem. The fix will be included in the next build of ODAC.

Leonid · Post by **Leonid** » Wed 07 Mar 2007 09:07

Do you have any information when next release will be published? This issue is very urgent for us.

Plash · Post by **Plash** » Wed 07 Mar 2007 09:31

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.