Hi,
This is the error log from the statement:-
"set selection [ns_db select $db "select address_book_id,first_names ||','|| line1 ||','|| ....." up to the end of that very statement !!
Note below: -
[10/Jun/2003:09:30:44][11041.286725][-conn273-] Error: ora8.c:1500:ora_exec:
error in `OCIStmtExec
ute ()': ORA-01745: invalid host/bind variable name
SQL: select first_names ||','||line1 ||','||city as address from address_book where
address_book_i
d= !>>>!
[10/Jun/2003:09:30:44][11041.286725][-conn273-] Error: dbinit:
error(,ora8.c:1500:ora_exec: error
in `OCIStmtExecute ()': ORA-01745: invalid host/bind variable name
SQL: select first_names ||','||line1 ||','||city as address from address_book where
address_book_i
d= !>>>!): 'select first_names ||','||line1 ||','||city as address from address_book where
address
_book_id=:'
[10/Jun/2003:09:30:44][11041.286725][-conn273-] Error: Database operation
"select" failed (exception NSDB, "Query was not a statement returning rows.")
while executing
"ns_db select $db "select first_names ||','||line1 ||','||city as address from
address_book where
address_book_id=:$address_id""
invoked from within
"set selection [ns_db select $db "select first_names ||','||line1 ||','||city as address
from address_book where address_book_id=:$address_id"]"
(file "/web/nspapp/www/nspapp/delivery/delivery-add.tcl" line 88)
invoked from within
"source [ad_conn file]"
(procedure "rp_handle_tcl_request" line 2)
invoked from within
"rp_handle_tcl_request"
invoked from within
"catch $handler error"
invoked from within
"rp_abstract_url_server"
Thanks in advance,
divya