Re: InStr and Length Problem, ora-01460

From: Ashley Morgan <amorgan_at_onet.co.uk>
Date: Tue, 15 Nov 2005 08:34:01 -0000
Message-ID: <43799d79$0$9494$ed2619ec@ptn-nntp-reader02.plus.net>

Hi Mark,

Thanks for the initial feedback.

To Answer your questions, String1 is a parameter which has been passed into
the Sp (Varchar2) whereas string2 is an integer value (from the DB) which has been Cast into a Varchar2.The version of Oracle which is being used is 9.2.0.4

Any help with this matter would be appreciated.

Regards

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1132017011.381084.58690_at_g44g2000cwa.googlegroups.com...
> Ashley, please do not cross-post.
>
> It is difficult to tell from the posted statement but are string1 and
> string2 column variables or pl/sql variables. Being that the statement
> is an SQL statement then the instr function is the SQL instr function
> and is different from the pl/sql instr function.
>
> You would reference the pl/sql instr function something like this:
> If instr(v_string1, v_string2 ) > 0 then .....
>
> A database varchar2 datatype used as a table column can be up to 4,000
> bytes in length and no more. A pl/sql varchar2 variable can be 32K.
> You usually read table character column values into pl/sql variables
> when you need to work with char strings over 4,000 bytes and you are
> not using CLOB datatypes.
>
> Your Oracle version is also important information for post since with
> version 9.2 and up the instr function can be used on CLOB's while in
> 8.1 it cannot.
>
> HTH -- Mark D Powell --
>

---

I am using the free version of SPAMfighter for private users. It has removed 391 spam emails to date.
Paying users do not have this message in their emails. Try www.SPAMfighter.com for free now! Received on Tue Nov 15 2005 - 02:34:01 CST