Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!chekhov.conxion.net!news.oracle.com!not-for-mail
From: "Sunil" <sunil_franklin@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: substr() woes in GERMAN_GERMANY.WE8MSWIN1252
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <zCNGc.2$z9.51@news.oracle.com>
Date: Wed, 7 Jul 2004 12:47:10 +0530
NNTP-Posting-Host: 152.69.157.120
X-Trace: news.oracle.com 1089185311 152.69.157.120 (Wed, 07 Jul 2004 00:28:31 PDT)
NNTP-Posting-Date: Wed, 07 Jul 2004 00:28:31 PDT
Xref: core-easynews comp.databases.oracle.server:225126
X-Received-Date: Wed, 07 Jul 2004 00:17:07 MST (news.easynews.com)

Experts,
    I have code like the following which works when NLS_LANG env variable is
not set but the moment I set my nls_lang variable to
GERMAN_GERMANY.WE8MSWIN1252, it fails with " ORA-06502: PL/SQL: numerisch
oder Wertefehler : Fehler bei Konvertierung von Zeichen zu Zahl "
    Any ides on how to overcome this.

   function get_major_version(p_version_str in varchar2)
    return pls_integer as
        l_position integer;
        l_version_int integer;
    begin
        l_position := instr(p_version_str, '.');
        l_version_int := to_number(substr(p_version_str, 1, l_position));
        return l_version_int;
    end;

Thanks,
Sunil.