connection from Perl 5.8.5 to Oracle 7.3.4 database

From: Yahui Shang (yahui.shang_at_globalstar.com)
Date: 01/09/05

  • Next message: Jeff Urlwin: "RE: Perl 5.6 to 5.8 caveats for DBI" 
    Date: Sat, 08 Jan 2005 16:57:07 -0800
To: dbi-users@perl.org

    Hello:

     I am using perl version 5.8.5 to connect to Oracle 7.3.4 database. I
    can fetch Date, Number, Float type of data from that database, but not
    VARCHAR2 type of data. The error message is:

    DBD::Oracle::db prepare failed: ORA-24328: illegal attribute value (DBD
    ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM) [for Statement "SELECT
    convert(CC_ACCOUNT_NUM,
     'WE8ISO8859P1', 'WE8DEC')
            FROM TEMP_PCC_BATCH_PAYMENT"] at x line 23.

    I have tried various options to reset NLS_LANG (to UTF8), however, none
    of them works. Could someone shed some lights on this issue? Really
    appreciate any help.

    Yahui

  • Next message: Jeff Urlwin: "RE: Perl 5.6 to 5.8 caveats for DBI"

    Relevant Pages

    • Re: Limiting Large Result Sets
      ... Oracle 9i - Database ... Using query based approach, i was able to retreive all the million rows ... Fetch Size ... rows at a time from the database cursor. ...
      (comp.lang.java.programmer)
    • Re: Bound variables produce different result to fetching field by fiel
      ... fetch the row and then fetch each field from the row. ... string which is the representation a field has if it is NULL. ... The source code for the calling program is here...it is CTLU001. ... There are many files to set up a database here...but any database will ...
      (microsoft.public.data.odbc)
    • Re: Advice about fetching user information
      ... Just fetch the information you need WHEN you need it. ... but if I need to fetch information for 100 members on one page ... Design your database smart. ... table for that userid. ...
      (comp.lang.php)
    • Re: What is faster? C++ vector sort or sort in database
      ... > I have to fetch values from a database and store them in a vector in ... specific compare operation, you can specify the appropriate functor as ...
      (comp.lang.cpp)
    • Re: RealThinClient SDK 1.8q > GPL Open Source with Demos
      ... When you fetch the top level rows from a query, all other rows are stored on ... the database engine waiting to be fetch. ...
      (borland.public.delphi.thirdpartytools.general)