Toad World® Forums

only the first put_line statement works

Hi,

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

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

Thanks

Hi jtalib,

Could you pls post your code or picture to help us reproduce?

Thanks,

Michael

Hi,

thanks for the update.

I have the below code:

procedure Test99 is
x NUMBER := 1;
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE(‘This loop has executed’||TO_CHAR(x)||’ time(s)’);
x := x +1;
EXIT WHEN x > 5;
END LOOP;
END;

when I run it in SQL plus I am getting 5 lines but when I am running it in SQL navigator I am getting only one line.

please help

Thanks

Hi jtalib,

This is a bug we have already fixed in v7.0.1, you can install our patch to upgrade to v7.0.1 or later version.

Michael

Dear Michael,

Thanks for the update. can you please provide me with a download link for the patch?

BR,

Jalal

Hi Jalal,

This issue has been fixed in our v7.0.1 patch build. you can download it from our support link:

support.quest.com/…/download-new-releases

Thanks a lot for your feedback.

Thanks again,

Michael

Dear Michael,

I tried to download the patch but I got a message saying “Please contact Support Renewals to renew your support.”.

please note that we bought the license already some time back.

Sorry I can’t new post.

I have created a new database user. I granted following system privileges in TOAD.

select any table

alter any table

drop any table

I found that account can select, alter, drop table of other schema’s tables. So how can I restrict the that account to alter, drop only its owned tables and select all schema’s table?

You probably don’t need to grant alter/drop any table to the user if you only want to allow it to alter/drop its own tables.

Hi all,

can some one help me with me issue?

BR,

jtalib

Hi jtalib,

Did you still have problem when you tried to download the patch?

Michael

Dear Michael,

Good day.

the patch requires a NEW license!!! why I Cannot use my old license?

Hi jtalib,

You may try to contact support to update your license.

we have update the license format in the new version of Nav

Thanks,

Michael