only the first put_line statement works

SQL Navigator
1

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

2

Hi jtalib,

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

Thanks,

Michael

3

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

4

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

5

Dear Michael,

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

BR,

Jalal

6

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

7

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.

8

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?

9

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.

10

Hi all,

can some one help me with me issue?

BR,

jtalib

11

Hi jtalib,

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

Michael

12

Dear Michael,

Good day.

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

13

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