Dbd Error Ora-01406
Blog Extensions Documentation Community Development Tasks Download Support You are here: Foswiki>Support Web>SupportQuestions>Question1122 (29 Jan 2014, MichaelDaum)Edit AttachThis question about This website: Task filed Oracle Long Column Type I got this oracle error while using the SqlPlugin: ERROR: DBD::Oracle::st fetchrow_hashref failed: ORA-24345: A Truncation or null fetch error occurred (DBD ERROR: ORA-01406 error on field 2 of 2, ora_type 8, LongReadLen too small and/or LongTruncOk not set) [for Statement " select view_name,text from all_views "] As a workaround I patched lib/Foswiki/Plugins/SqlPlugin/Connection.pm by adding the following near the end of the connect function: $db->{LongTruncOk}=1; $db->{LongReadLen}=1024; This makes the sql statement to truncate but not to fail if the column is too long and changes the length from 80 to 1024, which is long enough in my usecase. See man DBD::Oracle for an explanation of these options. -- HansJosefKoehler - 29 Jun 2012 Thanks for the patch. See Tasks.Item12737 -- MichaelDaum - 29 Jan 2014 Commenting is disabled while not logged in QuestionForm edit Subject This website Extension SqlPlugin Version Foswiki 1.1.3 Status Task filed Related Topics Edit |Attach|Print version|History: r2 SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Poetry RecentThreads NewestNodes Donate What'sNew on May 30, 2016 at 11:42UTC http://code.activestate.com/lists/perl-dbi-users/23484/ ( #1164494=perlquestion: print w/replies, xml ) Need Help?? wal has asked dbd error for the wisdom of the Perl Monks concerning the following question: hi there i get an truncation error on a field but don't dbd error ora-01406 know why DBD::Oracle::st fetchall_arrayref failed: ORA-24345: A Truncation or n +ull fetch error occurred (DBD ERROR: ORA-01406 error on field 8 of 12 +2, ora_type 1) [for Statement "SELECT "ADVERTISEMENT_ID","DELIVERY_GR +OUP_ID","PUBLISHING_GROUP_ID","ADDRESS_ID","PERSON_ID","REF_PROPERTY" +,"REF_HOUSE","REF_OBJECT","VOLUME","OBJECT_CATEGORY","OBJECT_TYPE","D +ISTANCE_FROM_PUBLIC_TRANSPORT","DISTANCE_FROM_SHOPS","DISTANCE_FROM_K +INDERGARTEN","DISTANCE_FROM_SCHOOL","DISTANCE_FROM_SCHOOL2",to_char(" +PUBLISH_UNTIL", 'YYYY-MM-DD HH24:MI:SS'),"FLOOR","NUMBER_ROOMS","NUMB +ER_APPARTMENTS","SURFACE_LIVING","SURFACE_PROPERTY","SURFACE_USABLE", +"YEAR_BUILT","WITH_VIEW","FIRE_PLACE","CABLE_TV","LIFT","FAMILY","PAR +KING","GARAGE","ROOFFLOOR","BALCONY","SITUATION","TITLE",to_char("AVA +ILABLE_FROM", 'YYYY-MM-DD HH24:MI:SS'),"VISIT_NAME","VISIT_PHONE","VI +SIT_EMAIL","VISIT_REMARK","AD_DESCRIPTION","AD_DESCRIPTION2","RENT_NE +T","RENT_EXTRA","PRICE_UNIT","SELLING_PRICE","OFFER_TYPE","SENDER_ID" +,"CURRENCY","YIELD","CONTACT_PERSON","TARGET_DESTINATION","DATA_DELIV +ERER_ADDRESS_ID","URL",to_char("TIMESTAMP", 'YYYY-MM-DD HH24:MI:SS'), +"AD_LOGO",to_char("CREATED", 'YYYY-MM-DD HH24:MI:SS'),"BILLING_ADDRES +S_ID","BILLING_NUMBER","DISTANCE_FROM_MOTORWAY","ROOM_HEIGHT","HALL_H +EIGHT","MAX_FLOOR_LOADING","CARRYING_CAPACITY_CRANE","CARRYING_CAPACI +TY_ELEVATOR","ISDN","WHEELCHAIR_ACCESS","ANIMAL_ALLOWED","RAMP","LIFT +ING_PLATFORM","RAILWAY_TERMINAL","RESTROOMS","WATER_SUPPLY","SEWAGE_S +UPPLY","POWER_SUPPLY","GAS_SUPPLY","MUNICIPAL_INFO","OBJECT_REFERENZ" +,"FTP_DIRECTORY","FILE_NAME",to_char("FILE_DATE", 'YYYY-MM-DD HH24:MI +:SS'),to_char("RECORD_DATE", 'YYYY-MM-DD HH24:MI:SS'),"AGENCY_ID","BU +ILT_NEW","BUILT_OLD","CORNER_HOUSE","GARDENHOUSE","HIGHFLOOR","MIDDLE +_HOUSE","MINERGY_BUILT","MINERGY_CERTIFIED","NUMBER_FLOORS","PLOT_CON +NECTED","ROOMMATE","SWIMMINGPOOL","UNDER_LAW","UNDER_ROOF","WORLD","Y +EAR_R
Perl Lists Python Lists PHP Lists Ruby Lists Tcl Lists ActiveState Lists Lists » perl-dbi-users RE: DBD::Oracle 1.15 crash - 9i: strange behaviour with bind parameters in select list From: Kircher, Gerhard