Turkbear wrote:
> "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) -
Use dynamic SQL.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Mar 19 2004 - 14:46:41 CST
