Problem with DBMS_OUTPUT.GET_LINES

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by MaximG » Tue 20 Jun 2017 14:02

We tested the work of ODAC with the DBMS_OUTPUT package according to your description and found no problems. We have successfully executed the DBMS_OUTPUT.PUT_LINE method using the UseUnicode option and without it. For further investigation, send us a small complete sample, in which the problem occurs. You can do it via the e-support form (https://www.devart.com menu "Support" \ "Request Support"). The parameters description of the DBMS_OUTPUT.GET_LINES method can be found at: https://docs.oracle.com/database/121/TT ... TTPLP71209

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by sinys » Thu 29 Jun 2017 05:26

Hello,
I sent the demo to your e-mail a week ago. How fast we can get the fix?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by MaximG » Tue 04 Jul 2017 07:13

In the above code the cMaxLines constant is used as the numlines parameter value of the DBMS_Output.Get_Lines method. More details about this method parameters are available by the link: https://docs.oracle.com/database/121/TT ... TTPLP71209

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by sinys » Tue 04 Jul 2017 09:57

Have you any news about a fix for my demo?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by MaximG » Tue 04 Jul 2017 15:01

We continue investigation of possible reasons for such behavior. We will inform your the results shortly

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by sinys » Tue 25 Jul 2017 08:49

Any news?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by MaximG » Tue 25 Jul 2017 12:47

Thank you for your patience. We fixed this bug. The fix will be included in the next ODAC build. Currently, we can send you a night build including this fix. For this, provide us with your license number and IDE version you are interested in via the e-support form ( https://www.devart.com menu "Support"\"Request Support" )

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by sinys » Mon 31 Jul 2017 09:08

What is the next ODAC release (with this fix) date?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by MaximG » Thu 03 Aug 2017 11:39

We are planning to release new ODAC build next month

jfudickar
Posts: 202
Joined: Fri 10 Mar 2006 13:03
Location: Oberursel / Germany

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by jfudickar » Fri 30 Mar 2018 13:12

Good to see that the problem is realy solved now.
And that someone was able to reproduce it.

I was really frustrated that I was not able to build a sample which shows it.

But my problem is solved now also.

Regards
Jens

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem with DBMS_OUTPUT.GET_LINES

Post by MaximG » Fri 30 Mar 2018 14:21

We are glad that the problem was resolved. You can always contact us for any question regarding our products use

Post Reply