Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2011
    Posts
    3

    Unanswered: ORA-01458: invalid length inside variable character string

    We are facing the issue while retrieving the data from column which is of CLOB dataType.

    Configuration file settings with the application;
    DB: Oracle (10g) - Unicode database

    NLSLang AMERICAN_AMERICA.WE8MSWIN1252
    UnicodeFormat utf-8
    MaxSQLStatementLength 40000
    DoubleByteLengthOffset 4

    Mentioned above are params related to Unicode database settings;

    SQL quried from .NET client, get executed from RPC, i.e., pro*C Server.
    Though data persist in the table for CLOB (datatype), unable to retrieve when queried from the application.

    Surprisingly in few systems this behaviour does not persists.

    Early thanks for sharing your expertise/opinion in this context.

    Regards
    Raj

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It appears you have a problem.
    I'm am befuddled as to what you expect we can do for you.
    Errors results from a bug; either in your code (which we don't have) or in Oracle (which we can't change).
    Since you decided we did not need any useful details, You're On Your Own (YOYO)!

    Post complete results of
    SELECT * from v$version;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2011
    Posts
    3

    Youti, Dgescil

    Quote Originally Posted by anacedent View Post
    It appears you have a problem.
    I'm am befuddled as to what you expect we can do for you.
    Errors results from a bug; either in your code (which we don't have) or in Oracle (which we can't change).
    Since you decided we did not need any useful details, You're On Your Own (YOYO)!

    Post complete results of
    SELECT * from v$version;
    Thanks for quick response;

    Please find below the details;

    SQL> SELECT * from v$version;

    BANNER
    --------------------------------------------------------------------------------

    Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
    PL/SQL Release 11.1.0.6.0 - Production
    CORE 11.1.0.6.0 Production
    TNS for Solaris: Version 11.1.0.6.0 - Production
    NLSRTL Version 11.1.0.6.0 - Production

  4. #4
    Join Date
    Feb 2005
    Posts
    57
    ORA-01458 invalid length inside variable character string

    Cause: An attempt was made to bind or define a variable character string with a buffer length less than the minimum requirement.

    Action: Increase the buffer size or use a different type.

  5. #5
    Join Date
    Feb 2011
    Posts
    3
    Thanks for your updates;

    But the strange behaviour found y'day that, upon building couple of big (cannot measure) criteria's could be able to retrive the CLOB data from the table;

    Once we retrieve on any component SELECT on CLOB data type holds good as long as session is up and running.

    But the problem is that execution begined from new session has similar problem (ORA-01458);

    For your reference pls take a look on below section copied from Oracle customer support portal;

    Reference:
    Bug:2668683 VARCHAR RESULTS IN ORA-1458 OR NO DATA FETCHED

    Fix: This is fixed in Pro*C 9.2.0.3 and higher versions.

    Workaround: Use word-aligned length for the host variable

    For eg :
    varchar v_sa[10][49]; --> No Data Fetched

    change to:
    varchar v_sa[10][50 or 58 or 66 or 74 and so on];

    Let me know your inputs on the same.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •