oracle - pass sqlplus value to shell variable -


the below picture shows gets returned when run sqlplus in shell

shell1

but when run "run" command:

powershell.exe -noexit c:\sqltriggers\voicetrigger2.ps1

with voicetrigger2.ps1 this:

$(sqlplus user/pass@omp1 '@c:\sqltriggers\voiceblocktrig.sql');

i this:

shell2

i should expect 3 back. issue is, try set variable, , if integer greater zero, run bat file. don't think sqlplus returning integer value. think returning this:

count(*)       3

how return integer value sqlplus command?

sql*plus isn't returning anything, it's displaying result of query on standard output. direct call show 3 can set heading off in sql script, , call sql*plus -s flag suppress banner. want exit @ end of sql script doesn't stay sitting @ sql> prompt.

the same applies powershell call, there's else going on there; 17 line number means it's waiting more input , hasn't executed commands in sql script, suggests either query without terminating ; or /, or pl/sql block without terminating /. if it's same sql ran in first example bit odd should behave same. should add sql script contents question see might wrong.

the thing can think of change behaviour if had login.sql includes set sqlterminator command, you'd have picking different login.sql files 2 calls... plausible if powershell has own environment variables, perhaps.


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more