Ashley Morgan wrote:
> 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!
- Please stop top posting.
- Your explanation still makes no sense. If you want help
post the actual SQL not some made-up version that does not
communicate what is actually going on.
And also the DDL for the table.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Nov 15 2005 - 09:54:12 CST
