Start a new topic

PL/SQL in dbvis 8.0

[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

[This reply is migrated from our old forums.]

Re: PL/SQL in dbvis 8.0
Mikael, There is no change of running SQL blocks in 8.0 compared to previous versions. What error do you get? Regards Roger
[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, The script is run on an old Oracle version 9 database. I have auto commit turned off and I start the DBMS output. The error message is (sorry for Swedish Locale) 11:20:56 [BEGIN - 0 row(s), 0.000 secs] [Error Code: 6550, SQL State: 65000] ORA-06550: rad 1, kolumn 7: PLS-00103: Påträffade symbolen "" då en av följande förväntades: begin case declare exit for goto if loop mod null pragma raise return select update while with pipe Symbolen "" ignorerades. ORA-06550: rad 2, kolumn 100: PLS-00103: Påträffade symbolen "" då en av följande förväntades: . ( , * @ % & - + / at mod rem as from || ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors] I have attached the script itself.
[This reply is migrated from our old forums.]

Re: PL/SQL in dbvis 8.0
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
[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
[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
[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
[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
[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
[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
[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
[This reply is migrated from our old forums. The original author name has been removed]

Re: PL/SQL in dbvis 8.0
HI, Now it's working right. Thanks. :-)