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..."

fdbsupport@mednet.ucla.edu