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"
