nsoracle.c:3904:ora_tcl_command: error in `OCIStmtExecute ()': ORA-24324: service handle not initialized
SQL:
SELECT /*+ first_rows */
outgoing,
CASE WHEN LOWER(:url) LIKE LOWER(outgoing) || '%' THEN 1 ELSE 0 END as recursive,
is_exact
FROM wg_redirect_mview
WHERE LOWER(incoming) = LOWER(:checkurl) AND
(sysdate BETWEEN NVL(start_date,sysdate-1) AND NVL(end_date,sysdate+1)) AND
rownum = 1
while executing
"ns_ora 0or1row nsdb0 {
SELECT /*+ first_rows */
outgoing,
CASE WHEN LOWER(:url) LIKE LOWER(outgoing) || '%' THEN 1 ELSE 0 END as recursive,
is_exact
..."
("uplevel" body line 1)
invoked from within
"uplevel 2 [list ns_ora $type $db $sql] $args"
invoked from within
"db_exec 0or1row $db $statement_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle db {
set selection [db_exec 0or1row $db $statement_name $sql]
}"
(procedure "db_0or1row" line 19)
invoked from within
"db_0or1row get_redirect "
SELECT /*+ first_rows */
outgoing,
CASE WHEN LOWER(:url) LIKE LOWER(outgoing) || '%' THEN 1 ELSE 0 END as recursive,
is_exa..."
("for" body line 22)
invoked from within
"for {set loopindex $l} {$loopindex >= 0 } {incr loopindex -1} {
set checkurl ""
#
# build a url from the first element to the current element
#..."
(file "/web/wgbh/www/wgbh/index.vuh" line 19)
invoked from within
"source [ad_conn file]"
(procedure "rp_handle_tcl_request" line 3)
invoked from within
"$handler"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
$handler
} ad_script_abort val {
# do nothing
}"
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file -noredirect -extension_pattern ".vuh" "$root$prefix""
("uplevel" body line 3)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
ad_conn -set path_info [string range $path [expr [string length $prefix] - 1] end]
rp_serve_abstract_file -noredirect -extension_patt..."