[This topic is migrated from our old forums. The original author name has been removed]
Hi,
in old dbvis 7.1.5 I could run PL/SQL script by surrounding te script with --/ and / , e.g.
--/
begin
loop
end loop
end;
/
But this doesn't work in 8.0. How do I run PL/SQL script in 8.0?
regards - Mikael
Mikael,
Thanks!
In Tools->Tool Properties, select the General->SQL Editor->Statement Delimiters.
What are the settings for SQL Block Identifiers: Begin and End identifiers? These must be "--/" and "/" to match your script.
Regards
Roger
a
anonymous
said
over 13 years ago
[This reply is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Re: PL/SQL in dbvis 8.0
I haven't changed anything from original installation. So the delimiters are --/ and /
I have provided a screen dump that shows te properties.
regards - Micke
Roger Bjärevall
said
over 13 years ago
[This reply is migrated from our old forums.]
Re: PL/SQL in dbvis 8.0
Hej Mikael,
Very strange...
I just tried and get these more normal errors due to non existing objects:
[nobr]
[pre]
10:39:53 [BEGIN - 0 row(s), 0.000 secs] [Error Code: 6550, SQL State: 65000] ORA-06550: line 4, column 33:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 2, column 18:
PL/SQL: SQL Statement ignored
ORA-06550: line 8, column 22:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 8, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 9, column 9:
PLS-00201: identifier 'VALIDATE_ROWS_AFFECTED' must be declared
ORA-06550: line 9, column 9:
PL/SQL: Statement ignored
ORA-06550: line 10, column 55:
PLS-00364: loop index variable 'REC' use is invalid
ORA-06550: line 10, column 9:
PL/SQL: Statement ignored
ORA-06550: line 11, column 21:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 11, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 12, column 9:
PLS-00201: identifier 'VALIDATE_ROWS_AFFECTED' must be declared
ORA-06550: line 12, column 9:
PL/SQL: Statement ignored
ORA-06550: line 14, column 12:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 14, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 15, column 12:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 15, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 16, column 5:
PLS-00201: identifier 'PL' must be declared
ORA-06550: line 16, column 5:
PL/SQL: Statement ignored
ORA-06550: line 17, column 5:
PLS-00201: identifier 'PL' must be declared
ORA-06550: line 17, column 5:
PL/SQL: Statement ignored
[/pre]
[/nobr]
Can you please enable debug mode in DbVisualizer and then re-run the SQL? Do this in Tools->Debug Window, enable "Debug DbVisualizer". Post or email the output.
Regards
Roger
support@dbvis.com
a
anonymous
said
over 13 years ago
[This reply is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Re: PL/SQL in dbvis 8.0
Hi,
I've got the same problem.
The easiest examples for dbvis 7.1.5 and 8.0 as attachments.
Regards
Andrzej
Roger Bjärevall
said
over 13 years ago
[This reply is migrated from our old forums.]
Re: PL/SQL in dbvis 8.0
Andrzej,
Can you please enable debug of DbVisualizer? Do this in Tools->Debug Window, enable "Debug DbVisualizer". Post or email the output when running the SQL as you have in the screenshot.
Also another test is to remove the --/ and / and then execute the SQL using SQL->Execute Buffer. What result do you get?
Regards
Roger
support@dbvis.com
a
anonymous
said
over 13 years ago
[This reply is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Re: PL/SQL in dbvis 8.0
Hi,
Sadly problem still exists.
Both methods SQL->Execute Current and Execute Buffer get the same result.
Log files from debugger as attachments.
Regards
Andrzej
PS.
Maybe problem is in editor , it sends some unexpected character to jdbc driver ?
Edited by: Andrzej Wojciechowski on 2011-06-29 09:58
Roger Bjärevall
said
over 13 years ago
[This reply is migrated from our old forums.]
Re: PL/SQL in dbvis 8.0
Thanks for your valuable input.
We have now identified the problem and a fix will be included in the next version.
We plan to release it this week.
Thanks again.
Regards
Roger
Roger Bjärevall
said
over 13 years ago
[This reply is migrated from our old forums.]
Re: PL/SQL in dbvis 8.0
MIkael and Andrzej,
This is now fixed in the 8.0.1 version.
Regards
Roger
a
anonymous
said
over 13 years ago
[This reply is migrated from our old forums. The original author name has been removed]
anonymous