oracle - DBeaver simple query ORA-00911 invalid character -

-

i switching sqldeveloper dbeaver in work oracle 10g database, have oracle instantclient exact version of database.

i not make scripts, bunch of queries, select, update. had collection of them, each on 1 or few lines, semicolon @ end, followed 2 dashes , comment. multiple line statements visual separation separated lines of many dashes.

sqldeveloper treated such system well, ctrl+enter executed line (or group last comment or semicolon next semicolon), ignored comment after or before. copied whole collection 1 programs main window other (sql editor). usage results weird.

example in new sql editor tab (table names changed, ignore if got reserved words):

select * file_movement movement_status != 'moved' , last_update > sysdate -10 order last_update desc;--my comment, explanation select * activity activity_type = 'generator' , status = 'created' , started > sysdate -10 order started desc;--my other comment

the first 1 executes expected ctrl+enter, line start flashes single triangle , execution log shows command until semicolon. when cursor placed @ second line followed ctrl+enter, triangles before both lines, after first lines semicolon until second lines end including both comments gets selected , ora-00911 pops up. selected text shows in execution log.

if put empty line between them, whole second line gets selected , logged , same error pops up.

what stop such behaviour , make second line execute same way first - without previous , next comment? there language or line end or comment settings in dbeaver have missed?

few last versions of dbeaver act acceptable. though previous lines comment comes in statement executed, acts expected. correct statement executed, log shows comment start of query, ignored. can live with.


Comments

Post a Comment

Popular posts from this blog

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that? ...
Read more

routes - Laravel 4 Wildcard Routing to Different Controllers -

-
realizing i'm going take beating this, have several questions "best practices" when constructing laravel route. do laravel routes run "first come first serve" top bottom? if route found, pass control controller (or perform action) , terminate? i have part of application acts url shortner. so, route looks this: route::get('/{id}', array('as' => 'home.text', 'uses' => 'homecontroller@text'), function($id){ //make sure id exists before pushing controller. if (storage::where('shortcode','=', $id)->count() > 0) { // route found } }); how can improved? one, i'm not sure how pass processing on controller conditionally.. sort of controller::make() ..? 3) there better way in laravel check if record exists versus doing mode::where('column','=','value')->count() 4) have legacy urls http://url.com/?...
Read more

cross browser - XSLT namespace-alias Not Working in Firefox or Chrome -

-
i transforming xhtml xhtml, need xslt stylesheet part of resulting document (the stylesheet contained in <script type"text/template"> element. using the xsl:namespace-alias instruction, works fine in ie, fails in both chrome , firefox. here relevant code: <xsl:output doctype-system="about:legacy-compat" omit-xml-declaration="yes" indent="yes" method="html" media-type="application/xhml" encoding="utf-8"/> <xsl:namespace-alias stylesheet-prefix="wxsl" result-prefix="xsl" /> <xsl:template match="head"> <!-- code omitted clarity --> <script type="text/template"> <wxsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns="http://www.w3.org/1999/xhtml" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:eli="local"> ...
Read more