'|| ''|| ''|| '' from copies c, locs l, shelves s, sub_locs sl where c.loc = l.loc(+) and sl.sl_id(+) = c.sl_id and c.shelf = s.shelf(+) and c.copycat = '_JHLD' and c.titleno=' || TO_CHAR(t.titleno) || order by c.copyno
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "
CGI error (version=Header: glue.c 3.0.9):
(in text<\n showlabel = tr...>
run from text< ehref = std_ehref\n...>
run from text< cf_due = decode(copy_...>run from filerun from filerun from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ xif("cond=already_looped", "span_end", "") already_looped="true" spancode = decode(aval, "isn", concat(""), concat("")) spancode trth=decode(array_to_show, "rgtbar", "", decode(aval, "title", ttrth, trth)) trth2=decode(array_to_show, "rgtbar", trth3, decode(aval, "title", ttrth2, trth2)) displaylabel = decode(array_to_run, "show", showlabel, false) blanklabel = "" xif("cond=displaylabel", "", "label = blanklabel olstf_label = blanklabel syndplus_label = blanklabel ltfl_label = blanklabel ") xif("cond=showlabel", " showlabel = false format(copy_footer) cf_due = false format(trth) label Exec(olstf_label) Exec(syndplus_label) Exec(ltfl_label) format(trth2) ", "") secsearch=decode(session, "-1", false, decode(link, "", false, true)) xif("cond=secsearch", "cgianchor = GetCol(3) decode(cgianchor, false, nullstr, ahref) decode(cgianchor, false, nullstr, concat(CGI, link)) col2=decode(use_col4, true, GetCol(4), GetCol(2)) decode(link_string, true, UrlEncode(col2), col2) decode(cgianchor, false, nullstr, ehref)", "") use_col4=false this_str = GetCol(1) this_str = fandr(this_str, " ", "") odd = decode(odd, "white;", "#f9f9f9;", "white;") this_str = fandr(this_str, "odd;", odd) fandr(this_str, " ", "
") decode(session, "-1", "", decode(link, "", "", "")) post_row
/ARG 2/ select htmlescape(titles_displays.getordstatus_display(' || TO_CHAR(t.titleno) ||)) from dual minus select null from dual
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "
CGI error (version=Header: glue.c 3.0.9):
(in text<\n showlabel = tr...>
run from text< ehref = std_ehref\n...>
run from text< cf_due = decode(copy_...>run from filerun from filerun from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ xif("cond=already_looped", "span_end", "") already_looped="true" spancode = decode(aval, "isn", concat(""), concat("")) spancode trth=decode(array_to_show, "rgtbar", "", decode(aval, "title", ttrth, trth)) trth2=decode(array_to_show, "rgtbar", trth3, decode(aval, "title", ttrth2, trth2)) displaylabel = decode(array_to_run, "show", showlabel, false) blanklabel = "" xif("cond=displaylabel", "", "label = blanklabel olstf_label = blanklabel syndplus_label = blanklabel ltfl_label = blanklabel ") xif("cond=showlabel", " showlabel = false format(copy_footer) cf_due = false format(trth) label Exec(olstf_label) Exec(syndplus_label) Exec(ltfl_label) format(trth2) ", "") secsearch=decode(session, "-1", false, decode(link, "", false, true)) xif("cond=secsearch", "cgianchor = GetCol(3) decode(cgianchor, false, nullstr, ahref) decode(cgianchor, false, nullstr, concat(CGI, link)) col2=decode(use_col4, true, GetCol(4), GetCol(2)) decode(link_string, true, UrlEncode(col2), col2) decode(cgianchor, false, nullstr, ehref)", "") use_col4=false this_str = GetCol(1) this_str = fandr(this_str, " ", "") odd = decode(odd, "white;", "#f9f9f9;", "white;") this_str = fandr(this_str, "odd;", odd) fandr(this_str, " ", "
") decode(session, "-1", "", decode(link, "", "", "")) post_row
/ARG 2/ select htmlescape(titles_displays.getordstatus_display(' || TO_CHAR(t.titleno) ||)) from dual minus select null from dual
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "
CGI error (version=Header: glue.c 3.0.9):
(in text<\n showlabel = tr...>
run from text< ehref = std_ehref\n...>
run from text< cf_due = decode(copy_...>run from filerun from filerun from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ xif("cond=already_looped", "span_end", "") already_looped="true" spancode = decode(aval, "isn", concat(""), concat("")) spancode trth=decode(array_to_show, "rgtbar", "", decode(aval, "title", ttrth, trth)) trth2=decode(array_to_show, "rgtbar", trth3, decode(aval, "title", ttrth2, trth2)) displaylabel = decode(array_to_run, "show", showlabel, false) blanklabel = "" xif("cond=displaylabel", "", "label = blanklabel olstf_label = blanklabel syndplus_label = blanklabel ltfl_label = blanklabel ") xif("cond=showlabel", " showlabel = false format(copy_footer) cf_due = false format(trth) label Exec(olstf_label) Exec(syndplus_label) Exec(ltfl_label) format(trth2) ", "") secsearch=decode(session, "-1", false, decode(link, "", false, true)) xif("cond=secsearch", "cgianchor = GetCol(3) decode(cgianchor, false, nullstr, ahref) decode(cgianchor, false, nullstr, concat(CGI, link)) col2=decode(use_col4, true, GetCol(4), GetCol(2)) decode(link_string, true, UrlEncode(col2), col2) decode(cgianchor, false, nullstr, ehref)", "") use_col4=false this_str = GetCol(1) this_str = fandr(this_str, " ", "") odd = decode(odd, "white;", "#f9f9f9;", "white;") this_str = fandr(this_str, "odd;", odd) fandr(this_str, " ", "
") decode(session, "-1", "", decode(link, "", "", "")) post_row
/ARG 2/ select ''||htmlescape(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition))||'' from titles t where t.articleno = ' || TO_CHAR(t.titleno) || and t.mediatp = 'BVOL' order by t.repeat_seq, t.titleno
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "
CGI error (version=Header: glue.c 3.0.9):
(in text<\n showlabel = tr...>
run from text< ehref = std_ehref\n...>
run from text< cf_due = decode(copy_...>run from filerun from filerun from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ xif("cond=already_looped", "span_end", "") already_looped="true" spancode = decode(aval, "isn", concat(""), concat("")) spancode trth=decode(array_to_show, "rgtbar", "", decode(aval, "title", ttrth, trth)) trth2=decode(array_to_show, "rgtbar", trth3, decode(aval, "title", ttrth2, trth2)) displaylabel = decode(array_to_run, "show", showlabel, false) blanklabel = "" xif("cond=displaylabel", "", "label = blanklabel olstf_label = blanklabel syndplus_label = blanklabel ltfl_label = blanklabel ") xif("cond=showlabel", " showlabel = false format(copy_footer) cf_due = false format(trth) label Exec(olstf_label) Exec(syndplus_label) Exec(ltfl_label) format(trth2) ", "") secsearch=decode(session, "-1", false, decode(link, "", false, true)) xif("cond=secsearch", "cgianchor = GetCol(3) decode(cgianchor, false, nullstr, ahref) decode(cgianchor, false, nullstr, concat(CGI, link)) col2=decode(use_col4, true, GetCol(4), GetCol(2)) decode(link_string, true, UrlEncode(col2), col2) decode(cgianchor, false, nullstr, ehref)", "") use_col4=false this_str = GetCol(1) this_str = fandr(this_str, " ", "") odd = decode(odd, "white;", "#f9f9f9;", "white;") this_str = fandr(this_str, "odd;", odd) fandr(this_str, " ", "
") decode(session, "-1", "", decode(link, "", "", "")) post_row
/ARG 2/SELECT '' || htmlescape(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition)) || '' FROM titles t WHERE t.articleno = ' || TO_CHAR(t.titleno) || AND t.mediatp = 'SISS' AND (NVL(t.copies, 0) > 0 OR (NVL(t.copies, 0) = 0 AND 'BVOL' = (SELECT mediatp FROM titles t2 WHERE t2.titleno = t.articleno))) AND (TO_NUMBER(TO_CHAR(t.issgen_startdate, 'YYYY')) >= TO_NUMBER(TO_CHAR(SYSDATE, 'YYYY')) - 20 OR t.issgen_startdate IS NULL) ORDER BY t.repeat_seq DESC, t.titleno DESC
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "
CGI error (version=Header: glue.c 3.0.9):
(in text<\n showlabel = tr...>
run from text< ehref = std_ehref\n...>
run from text< cf_due = decode(copy_...>run from filerun from filerun from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ xif("cond=already_looped", "span_end", "") already_looped="true" spancode = decode(aval, "isn", concat(""), concat("")) spancode trth=decode(array_to_show, "rgtbar", "", decode(aval, "title", ttrth, trth)) trth2=decode(array_to_show, "rgtbar", trth3, decode(aval, "title", ttrth2, trth2)) displaylabel = decode(array_to_run, "show", showlabel, false) blanklabel = "" xif("cond=displaylabel", "", "label = blanklabel olstf_label = blanklabel syndplus_label = blanklabel ltfl_label = blanklabel ") xif("cond=showlabel", " showlabel = false format(copy_footer) cf_due = false format(trth) label Exec(olstf_label) Exec(syndplus_label) Exec(ltfl_label) format(trth2) ", "") secsearch=decode(session, "-1", false, decode(link, "", false, true)) xif("cond=secsearch", "cgianchor = GetCol(3) decode(cgianchor, false, nullstr, ahref) decode(cgianchor, false, nullstr, concat(CGI, link)) col2=decode(use_col4, true, GetCol(4), GetCol(2)) decode(link_string, true, UrlEncode(col2), col2) decode(cgianchor, false, nullstr, ehref)", "") use_col4=false this_str = GetCol(1) this_str = fandr(this_str, " ", "") odd = decode(odd, "white;", "#f9f9f9;", "white;") this_str = fandr(this_str, "odd;", odd) fandr(this_str, " ", "
") decode(session, "-1", "", decode(link, "", "", "")) post_row
/ARG 2/ select LibraryWebViewOutput.GetWebViewOutput(' || TO_CHAR(t.titleno) ||, 'TITLES', 9) from dual minus select null from dual
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "
CGI error (version=Header: glue.c 3.0.9):
(in text<\n showlabel = tr...>
run from text< ehref = std_ehref\n...>
run from text< cf_due = decode(copy_...>run from filerun from filerun from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ xif("cond=already_looped", "span_end", "") already_looped="true" spancode = decode(aval, "isn", concat(""), concat("")) spancode trth=decode(array_to_show, "rgtbar", "", decode(aval, "title", ttrth, trth)) trth2=decode(array_to_show, "rgtbar", trth3, decode(aval, "title", ttrth2, trth2)) displaylabel = decode(array_to_run, "show", showlabel, false) blanklabel = "" xif("cond=displaylabel", "", "label = blanklabel olstf_label = blanklabel syndplus_label = blanklabel ltfl_label = blanklabel ") xif("cond=showlabel", " showlabel = false format(copy_footer) cf_due = false format(trth) label Exec(olstf_label) Exec(syndplus_label) Exec(ltfl_label) format(trth2) ", "") secsearch=decode(session, "-1", false, decode(link, "", false, true)) xif("cond=secsearch", "cgianchor = GetCol(3) decode(cgianchor, false, nullstr, ahref) decode(cgianchor, false, nullstr, concat(CGI, link)) col2=decode(use_col4, true, GetCol(4), GetCol(2)) decode(link_string, true, UrlEncode(col2), col2) decode(cgianchor, false, nullstr, ehref)", "") use_col4=false this_str = GetCol(1) this_str = fandr(this_str, " ", "") odd = decode(odd, "white;", "#f9f9f9;", "white;") this_str = fandr(this_str, "odd;", odd) fandr(this_str, " ", "
") decode(session, "-1", "", decode(link, "", "", "")) post_row
/ARG 2/ select '
' || ''|| '' || '' || '' || '
Detalles del Título
'|| decode(l.locld, null, decode(s.shelfld, null, ' ', htmlescape(s.shelfld)), decode(s.shelfld, null, case when l.enable_profile = 'Y' and (';;' like '%;'||c.loc||';%' or ';;' = ';;') then '' end|| nvl(htmlescape(l.locld),' ')|| case when l.enable_profile = 'Y' and (';;' like '%;'||c.loc||';%' or ';;' = ';;') then '' end||(CASE WHEN sl.sl_desc IS NOT NULL THEN ' (' || sl.sl_desc || ')' END), case when l.enable_profile = 'Y' and (';;' like '%;'||c.loc||';%' or ';;' = ';;') then '' end|| nvl(htmlescape(l.locld),' ')|| case when l.enable_profile = 'Y' and (';;' like '%;'||c.loc||';%' or ';;' = ';;') then '' end||(CASE WHEN sl.sl_desc IS NOT NULL THEN ' (' || sl.sl_desc || ')' END)|| ' - ' || s.shelfld))||''||nvl(htmlescape(c.hld_summary), ' ')||''||decode(c.hld_start_date, null, ' ', htmlescape(to_char(c.hld_start_date, 'FMDD Mon YYYY'))|| ' - '||htmlescape(nvl(to_char(c.hld_end_date, 'FMDD Mon YYYY'),'')))||'
' || nvl(htmlescape(c.barcode),' ') || '' || case when l.enable_profile = 'Y' and (';;' like '%;' || c.loc || ';%' or ';;' = ';;') then '' end || nvl(htmlescape(l.locld),' ') || case when l.enable_profile = 'Y' and (';;' like '%;' || c.loc || ';%' or ';;' = ';;') then '' end || (CASE WHEN sl.sl_desc IS NOT NULL THEN ' (' || sl.sl_desc || ')' END) || '' || nvl(htmlescape(s.shelfld),' ') || '' || nvl(htmlescape(c.shelfmark),' ') || '' || htmlescape(cz.copystsd|| decode(c.loanst,'O', ' (' || to_char(c.retdate, 'DD-Mon-YYYY') || ')', '')) || '' || nvl(htmlescape(cc.copycatsd),' ') || '
Detalles del Título

 
>' from copies c, locs l, shelves s, copycats cc, copysts cz, sub_locs sl where c.loc = l.loc(+) and sl.sl_id(+) = c.sl_id and c.copycat = cc.copycat and c.copyst = cz.copyst and substr(c.copycat,1,1) != '_' and nvl(c.hide_in_webview, 'N') != 'Y' and nvl(cc.hide_in_webview, 'N') != 'Y' and nvl(cz.hide_in_webview, 'N') != 'Y' and c.shelf = s.shelf(+) and c.titleno=' || TO_CHAR(t.titleno) || and c.loc NOT IN ('BCC', 'BCFUP', 'BD') order by c.copyseq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-01756: la cadena entrecomillada no está terminada correctamente "