Hi Vaibhav
�
gsql was not recognized option?
�
Atul
---------------------------- Original Message ----------------------------
Subject: Re: SQL error ORA-00911 when a sql executed from a filter but works in
sqlplus
From: "vaibhav wadekar" <[email protected]>
Date: Wed, April 24, 2013 10:26 am
To: [email protected]
--------------------------------------------------------------------------
> Can you run the same SQL via driver which will help you understand the
> problem
>
> ./driver
> Log
> Provide the credential
> Init
> gsql
> Type the SQL statement
>
>
> Hope this helps
>
> Regards/Vaibhav
>
> On Wednesday, April 24, 2013, Atul Vohra wrote:
>
>> **
>>
>> All,
>>
>> I am trying to parse a remedy field ex:
>>
>> Remedy Field X = 'SMITH^ALLENX^WARD^JONES'
>>
>>
>>
>> Output saved in 4 different remedy fields
>>
>>
>> SMITH
>>
>> ALLENX
>>
>> WARD
>>
>> JONES
>>
>>
>> I have an filter that has a set field action with Data Source = SQL and
>> SQL QUERY -
>>
>> select regexp_substr('$X$','[^^]+', 1, level) from dual
>> connect by regexp_substr('$X$','[^^]+', 1, level) is not null;
>>
>> In the sql log I see the following -
>> select regexp_substr('SMITH^ALLENX^WARD^JONES','[^^]+', 1, level) from
>> dual
>> connect by regexp_substr('SMITH^ALLENX^WARD^JONES','[^^]+', 1, level) is
>> not null;
>>
>> *** ERROR *** ORA-00911: invalid character
>>
>> The same query above works fine in sql plus.
>>
>> We are on ARS 8.0, Oracle 11 g
>>
>> What am I doing wrong here? I could write a filter guide and parse it but
>> was not sure what is wrong here.
>>
>> Thanks
>> Atul
>>
>>
>>
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
