sql - Using sequence.nextval in subquery -

-

i want create template (via sql) can copied straight ms excel.

generally went pretty well, however, i've run problem field supposed store excel formula. field supposed used create insert statements in excel file, based on user input in 1 of columns of excel sheet.

here's code:

select -- other fields here [...], (select '="insert mytable values(" &c' || create_inserts_temp_seq.nextval || '&",''this column filled user in excel'',''"&d' || create_inserts_temp_seq.currval || '&"'',14,sysdate);"' dual) sql_statement mytable;

i getting error message ora-02287: sequence number not allowed here.

why not allowed in subquery? idea how fix this?

i must have access these values in order create functioning excel formula, these numbers reference respective excel rows...

the documentation includes restrictions, including:

currval , nextval cannot used in these places:

  • a subquery
  • ...

but don't need subquery here:

select -- other fields here [...], '="insert mytable values(" &c' || create_inserts_temp_seq.nextval   || '&",''this column filled user in excel'',''"&d'   || create_inserts_temp_seq.currval || '&"'',14,sysdate);"' sql_statement mytable;

this form doesn't generate error.

i suspect once reason isn't allowed in subquery because isn't clear, or deterministic, how many times subquery executed. if had worked in scenario might have got same insert statement every row in table, presumably isn't intention.


Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea
Read more

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more