Toad World® Forums

dbms_putline functions only first time

When i run the below code in SQL Navigator 7.0, only the first put_line statement works. The second put_line is ignored…


**** SCRIPT ENDED 19-Nov-2013 15:28:23 ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
**** SCRIPT STARTED Session: TUG_NEW@KFUDEV.WORLD(1) 19-Nov-2013 15:28:28 ****
DECLARE
BEGIN
DBMS_OUTPUT.Put_Line( ‘first line’ );
DBMS_OUTPUT.Put_Line( ‘second line’ );
END;
==>
PL/SQL block executed
first line

**** SCRIPT ENDED 19-Nov-2013 15:28:28 ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Can you please let me know what might be the problem?

Hi,

Can you please check the Oracle client you are using? We have some problems with client which is below 10gR2 (9i/10gR1), which has been fixed in 7.0 patch, but currently we are in some process to get it out, hopefully it will be available later this week.

So before you could use the patch, the only workaround is to update to a newer version of oracle client above 10.1.

Please let us know how you go, thanks.

Regards,

Shirly

Hello,

I am using Oracle Database 11g Enterprise Edition 11.2.0.3.0. The strange thing is that it works fine on my colleague’s machine. I even copied the preferences file from his sql navigator to mine, to check if it has anything to do with Navigator preferences.

Please let me know next steps.

Regards,

Anand

Hi Anand,

Did it work after you coping the preference file from others? So far I couldn’t reproduce your problem yet even with some related options changed in preference. If you still meet this issue can you please send us your profile to a further check?

Tools | Profile Manager | Backup profile

You can send the profile to me directly to: Shirly.Nie@quest.com

Thanks,

Shirly

Hi Anand,

Can you please double check again you Oracle Client version but NOT oracle database version?I reproduced you issue with client 10g1, please let me know which client version are you using, thanks.

We are on the way to getting 7.0.1 patch out soon, you can either update your client to a newer version, or wait for a few more days about our new 7.0.1 version with this issue fixed.

Please let us know how you go.

Thanks,

Shirly

Hello Shirly,

I have the same problem.

I use client 9.2.

Is it the problem ?

Etienne

Hi Etienne,

Yes it is the same problem in 7.0 release. It has been fixed in 7.0.1 patch, our support will let you know once it’s available, thanks.

Regards,

Shirly

Thanks a lot Shirly.

Etienne