'|| ''|| ''|| '' 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= order by c.copyno
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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()) from dual minus select null from dual
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-06553: PLS-306: wrong number or types of arguments in call to 'GETORDSTATUS_DISPLAY' "
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()) from dual minus select null from dual
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-06553: PLS-306: wrong number or types of arguments in call to 'GETORDSTATUS_DISPLAY' "
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 = and t.mediatp = 'BVOL' order by t.repeat_seq, t.titleno
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 = AND t.mediatp = 'SISS' AND NVL(t.include_in_opac, 'Y') = 'Y' 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')) - 10 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-00936: missing expression "
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(, 'TITLES', 17) from dual minus select null from dual
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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("")) ockableSearchField'>
"), 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))|| ''||htmlescape(DECODE(me.mediumld, NULL, m.mediatpld, m.mediatpld||' / '||me.mediumld)) || '' from titles t, mediatps m, media me where titleno = and t.mediatp = m.mediatp(+) and t.medium = me.medium(+)
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 decode(web_sess.allow(33518990, t.titleno), 'Y', ''||htmlescape(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition))||'', decode(t.mediatp, 'SISS', ''||htmlescape(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition))||'', htmlescape(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition)))) from titles t where titleno != connect by prior articleno = titleno start with titleno = order by level desc
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 decode(web_sess.allow(33518990, t.titleno), 'Y', ''||(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition))||'', 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 = and mediatp not in ('SISS', 'SART', 'BVOL', 'LLFPT') AND NVL(t.archived, 'N') = 'N' order by t.repeat_seq, t.titleno
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(hldsum) from titles where titleno = and hldsum is not null
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 decode(web_sess.allow(33518990, t.titleno), 'Y', '' || htmlescape(t.title || decode(t.subtitle, null, null, ' : ' || t.subtitle)) || '', htmlescape(t.title || decode(t.subtitle, null, null, ' : ' || t.subtitle))) || '
' || htmlescape(web_article_display.ArticleDisplay (t.titleno)) from titles t where t.articleno = and t.mediatp = 'SART' ORDER BY DECODE(t.repeat_seq, NULL, TO_NUMBER(regexp_substr(t.extent, 'd+')), t.repeat_seq) NULLS LAST, t.titleno
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 Names.GetDisplay(ta.authorno)||' ('||r.resbtytpld||')', ta.authorno, null from titleauths ta, resbtytps r where ta.resbtytp = r.resbtytp and substr(ta.resbtytp, 1, 1) != '_' and nvl(r.resbtytp_code, 0) = 0 and ta.titleno= order by ta.authseq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(publication.WebViewPubDisplay(pubno, 'DD-MON-YYYY')) from titlepub where titleno = order by repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 mxxi.PhysicalSeqAndPunct('Display', f.no_items, f.materialtp, f.trade_names, f.length, f.physical_chars, f.enrich, f.specific_enrich, f.special_char, f.dim_non_use, f.dim_use, f.weight, f.format, f.acc_material, f.acc_desc, f.binding, f.subseq_punct) from titlephysical f where f.titleno = order by f.repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(l.langld) from titlelangs t, langs l where t.titleno= and t.lang = l.lang order by repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(s.title||decode(ts.seq_text, '', '', ' ('||ts.seq_text||')')), htmlescape(s.title), null, s.title from titleseries ts, series s where ts.seriesno = s.seriesno and ts.titleno= order by ts.repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(decode(isn, NULL, NULL, decode(price, NULL, decode(qualification, NULL, isn, isn || ' (' || LTRIM(RTRIM(qualification, ')'), '(') || ')'), decode(qualification, NULL, isn || ' : ' || price, isn || ' (' || LTRIM(RTRIM(qualification, ')'), '(') || ') : ' || price)))) from titleisns where titleno= order by repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 /*+ index(titleclasses titleclasses_titleno) */ c.classmark, htmlescape(c.classmark), null, c.classmark from titleclasses tc, classtps ct,classes c where tc.titleno= and tc.domain = 'TITLE' and c.classmarkno=tc.classmarkno and c.classtp = ct.classtp and nvl(ct.classtp_code, 0) = 0 order by tc.repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 nvl(s.subject_disp, s.subjectld), s.subject, null from titlesubjs ts, subjects s, subjecttps st, titles t where ts.subject = s.subject and st.subjecttp=s.subjecttp and nvl(st.subjecttp_code, 0) in (0) and ts.titleno=t.titleno and t.titleno= and DECODE(';;', ';;', 1, INSTR(';;', ';' || NVL(serst, '') || ';')) > 0 order by ts.subjseq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(tn.note) from titlenotes tn, notetps nt where tn.titleno = and tn.notetp = nt.notetp and nvl(nt.show_in_webview, 'Y') = 'Y' order by tn.repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(ttp.titletpld || ': ' || title) from titletitles tt, titletps ttp where tt.titleno= and tt.titletp = ttp.titletp order by tt.repeat_seq asc
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(l.linktpld||': ')||''||htmlescape(t.title || decode(t.subtitle, '', '', ': ' || t.subtitle) || decode(t.stmnt_resbty, '', '', ' / ' || t.stmnt_resbty) || decode(t.edition, '', '', '. - ' || t.edition))||'' from titles t, titlexrefs x, linktps l where t.titleno = x.xreftitleno and x.linktp = l.linktp and x.titleno = and x.domain = 'TITLES' and x.xrefdomain = 'TITLES' and web_sess.allow(33518990, t.titleno) = 'Y' order by x.repeat_seq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 abstract from titles where titleno = and abstract is not null and DECODE(';;', ';;', 1, INSTR(';;', ';' || NVL(serst, '') || ';')) > 0
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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(NVL(o.title, SUBSTR(o.locator, INSTR(o.locator,'\',-1)+1))), TO_CHAR(o.objectno) || '&source=webvd&cgimime=' || REPLACE(tp.mime_type, '/', '%2F'), DECODE(in_db, 'Y', 'TRUE', 'TRUE') FROM titleobjs ot, objects o, objecttps tp WHERE ot.titleno = AND ot.objectno = o.objectno AND tp.objecttp = o.objecttp AND ot.domain = 'TITLES' ORDER BY ot.objectseq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "
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 '
'|| 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'),'')))||'
Detalles del Título
Detalles del Título

 
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 '' || 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),' ') || '' 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 cz.copyst not in ('DESCA','PPRES','PROBO','PPPAG','PBEBE','WRDW','WDRWW','NODIS','INCAT') and l.loc not in('CLUBL','CLUED','CULTU','COLBI','BELEN','CASTD','CLUMO','COLAU','MAIN','TAMAR','PARIS','PROPE','HIDRO','PRFER','EDUCA','CEDPL','ICOMF','CASTI') and c.titleno= order by c.copyseq
Call stack:
Exec(...)
xif(...)
ExecArray(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: missing expression "