plsql - How to Mimic a Continue Statement in a Cursor-For-Loop in Oracle 10G PL/SQL? -

-

in oracle 10g, there no continue statement. typically mimicked in explicit cursor such:

open c_cur ; <<cont>> loop     ...     if condition = 10         goto cont ;     end if; end loop; close c_cur ;

given loop keyword follows cursor in cursor-for-loop syntax, how can continue statement mimicked?

for rec in c_cur loop     ... end loop ; 

for rec in c_cur loop     ...     if condition = 10         goto cont ;     end if ;  <<cont>> null; -- end cannot preceeded <<marker>>  end loop ;

Comments

Post a Comment

Popular posts from this blog

Line ending issue with Mercurial or Visual Studio -

-
i seem have strange issue caused either visual studio or mercurial. localised single project, i'm guessing in project configuration causing issue. at difficult specify point, when perform action in visual studio, update every line ending in given file, means when @ file in sourcetree, every line has changed. i can replicate using nuget add package dependency; packages.config entirely replaced. if commit changes, including line endings, later same issue occur. workaround have shelve changes , reapply them, whereupon lines written correctly. i'm not sure application blame here. did make mistake of allowing sourcetree change mercurial configuration, issue have fixed, i'm not sure if has persisted. i thought might issue mercurial.ini files or hgrcs don't seem contain untoward. here's mercurial.ini [ui] username = .... [auth] bb.prefix = https://bitbucket.org/ bb.username = .... bb.password = .... [extensions] mq = rebase = [web] allow_push = * push_s...
Read more

python - Received unregistered task using Celery with Django -

-
i have celery setup django project , can't seem task run properly. i'm using django 1.4.3, celery 3.0.1, django-celery 3.0.17 , python 2.7 on ubuntu 13.04. i have verified rabbitmq-server running: sudo service rabbitmq-server status status of node rabbit@fenster ... [{pid,1667}, {running_applications,[{rabbit,"rabbitmq","3.0.2"}, {os_mon,"cpo cxc 138 46","2.2.9"}, {mnesia,"mnesia cxc 138 12","4.7"}, {sasl,"sasl cxc 138 11","2.2.1"}, {stdlib,"erts cxc 138 10","1.18.1"}, {kernel,"erts cxc 138 10","2.15.1"}]}, {os,{unix,linux}}, {erlang_version,"erlang r15b01 (erts-5.9.1) [source] [64-bit] [smp:8:8] [async-threads:30] [kernel-poll:true]\n"}, {memory,[{total,28112760}, {connection_procs,93432}, {que...
Read more

c# - Delving into the world of XML (Windows Phone) Error I dont understand (The ' ' character, hexadecimal value 0x20, cannot be included in a name.) -

-
so starting learn how use xml data within app , decided use free data cannot life of me working code far. (i have done few apps static data before hey apps designed use web right? :p) public partial class mainpage : phoneapplicationpage { list<xmlitem> xmlitems = new list<xmlitem>(); // constructor public mainpage() { initializecomponent(); loadxmlitems("http://hatrafficinfo.dft.gov.uk/feeds/datex/england/currentroadworks/content.xml"); test(); } public void test() { foreach (xmlitem item in xmlitems) { testing.text = item.title; } } public void loadxmlitems(string xmlurl) { webclient client = new webclient(); client.openreadcompleted += (sender, e) => { if (e.error != null) return; stream str = e.result; xdocument xdoc = xdocument.load(str); ***xmlitems = (from ite...
Read more