Error while inserting data

Post Reply
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

Error while inserting data

Post by gaurav.shetti »

I am getting the following error:

100 2009-07-21 13:20:34 profileMig_filter_options:100: FTN type 82 (varblobi): cannot convert to SQL type; assuming byte in the function vsvtx_setparam


this is happening when I am trying to insert data into a table.

this is the command that I am using to insert the data:
<sql novars "insert into person_profile_backup(id,person_id,last_name,first_name,middle_initial,preferred_name,
email,business_name,sub_business_name,function_name,ohr_id,supervisor_name,person_type,restricted_flag,
active_flag,folders_flag,org_dir_exclude_flag,expert_brief_desc,dialcomm,sc_last_name,sc_first_name,
location,other_info,image_path,job_family,tag_text,cdi_person_type,business_segment)
values(counter,$person_id,$last_name,$first_name,$middle_initial,$preferred_name,$email,
$business_name,$sub_business_name,$function_name,$ohr_id,$supervisor_name,$person_type,
$restricted_flag,$active_flag,$folders_flag,$org_dir_exclude_flag,$expert_brief_desc,
$dialcomm,$sc_last_name,$sc_first_name,$location,$other_info,$image_path,$job_family,
$tag_text,$cdi_person_type,$business_segment)"></sql>
User avatar
mark
Site Admin
Posts: 5515
Joined: Tue Apr 25, 2000 6:56 pm

Error while inserting data

Post by mark »

Post Reply