Mark Smith wrote:
> "Mark Smith" <marksmit_at_nortelnetworks.com> wrote in message
> news:eepd4d$al5$1_at_zcars129.ca.nortel.com...
>> I am a newbie, so this may be a simple question. I have a sql script
>> called p_chp_proc.sql, which creates a procedure called p_chp:
>>
>> CREATE OR REPLACE PROCEDURE p_chp( encoded IN VARCHAR )
>> IS
>> len int := length(encoded);
>> i int;
>> new_password varchar(30);
>> BEGIN
>> -- decode password
>> for i IN 1..len loop
>> new_password := substr(encoded, i*2, 1);
>> end loop;
>>
>> -- change password
>> EXECUTE IMMEDIATE 'ALTER USER db_audit IDENTIFIED BY ' || new_password;
>>
>> END p_chp;
>>
>>
>> When I try and run the script I get the error "SP2-0042: unknown command
>> "cr_p_chp" - rest of line ignored." Does anyone know what I am missing?
>> Thanks a lot.
> Typo...the error actually reads "SP2-0734: unknown command beginning
> "p_chp_proc..." - rest of line ignored."
The procedure's name is: p_chp
The error indicates that you typed: p_chp_proc
They generally work better when identical.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Wed Sep 20 2006 - 14:01:41 CDT
