Re: SQL Serious Challenge # 1 - Probably Not Much Fun

"Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca.x> wrote:

>Does it work in PL/SQL in 9i or 10g? I tried in 8174 and it failed:
>
> 1 declare
> 2 ls_result varchar2(10);
> 3 begin
> 4 select reverse('oracle') into ls_result from dual;
> 5* end;
>SQL> /
>select reverse('oracle') into ls_result from dual;
> *
>ERROR at line 4:
>ORA-06550: line 4, column 8:
>PLS-00201: identifier 'REVERSE' must be declared
>ORA-06550: line 4, column 1:
>PL/SQL: SQL Statement ignored

The REVERSE() Function( Not the REVERSE Keyword used in the INDEX clause) is a SqlPlus function and those do not work in Pl/Sql ( at least not in 8i) - Received on Fri Mar 19 2004 - 11:54:53 CST