nsoracle.c:1366:OracleSelect: error in `OCIStmtExecute ()': ORA-00904: "MEDICAL_SPECIALTY": invalid identifier SQL: -- Only show directly employed personnel by querying against acs_rels. select p.person_id personnel_id, p.first_names first_names, p.last_name last_name, titles.name personnel_title, decode(leader_p, 't', 1, 0) leader_p from inst_group_personnel_map igpm, persons p, inst_personnel ip, categories titles, acs_rels rels where titles.category_id = igpm.title_id and igpm.acs_rel_id = rel_id and rels.rel_type = 'membership_rel' and rels.object_id_one = :group_id and rels.object_id_two = p.person_id and p.person_id = ip.personnel_id and p.person_id in ( select distinct object_id_two from acs_rels where rel_type = 'membership_rel' and object_id_one in ( select distinct object_id_two from acs_rels where rel_type = 'subsite_for_party_rel' and object_id_one = :subsite_id ) ) order by !>>>!medical_specialty, last_name, first_names, personnel_id, personnel_title while executing "ns_ora select nsdb0 { -- Only show directly employed personnel by querying against acs_rels. select p.person_id personnel_id, p.first_name..." ("uplevel" body line 1) invoked from within "uplevel $ulevel [list ns_ora $type $db $sql] $args" invoked from within "db_exec select $db $full_statement_name $sql" ("uplevel" body line 2) invoked from within "uplevel 1 $code_block " invoked from within "db_with_handle -dbn $dbn db { set selection [db_exec select $db $full_statement_name $sql] set local_counter 0 # ..." ("uplevel" body line 6) invoked from within "uplevel 1 { if { !$append_p || ![info exists counter]} { set counter 0 } db_with_handle -dbn $dbn db { ..." (procedure "db_multirow_helper" line 2) invoked from within "db_multirow_helper" (procedure "db_multirow" line 68) invoked from within "db_multirow personnel group_personnel {} { set unique_titles($personnel_title) 1 }" ("uplevel" body line 51) invoked from within "uplevel { # -*- tab-width: 4 -*- ad_page_contract { @author helsleya@cs.ucr.edu } { {group_id:integer} {show:optional ""} {hide:optional ""..." (procedure "code::tcl::/web/fdb5/packages/institution/www/core-detail" line 2) invoked from within "code::tcl::$__adp_stub" ("uplevel" body line 12) invoked from within "uplevel { if { [file exists $__adp_stub.tcl] } { # ensure that data source preparation procedure exists and is up-to-date adp_init t..." (procedure "adp_prepare" line 2) invoked from within "adp_prepare" invoked from within "template::adp_parse [file root [ad_conn file]] {}" (procedure "adp_parse_ad_conn_file" line 6) 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 "$root/$extra_url"" ("uplevel" body line 2) invoked from within "uplevel $code" invoked from within "ad_try { rp_serve_abstract_file "$root/$extra_url" set tcl_url2file([ad_conn url]) [ad_conn file] set tcl_url2path..."