Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00940

10438Mar 14 2006 — edited Mar 14 2006
I have a procedure

create or replace procedure abc
(p_username in all_users.username%type)isbegin execute immediate 'alter user ' || p_username || ' account unlock';end;


I need to call this procedure from sqlplus.

I tried below but get error.

execute unlock_account ('usermane');
BEGIN unlock_account ('username'); END;

*
ERROR at line 1:
ORA-00940: invalid ALTER command
ORA-06512: at "schema.abc", line 3
ORA-06512: at line 1

DN
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2006
Added on Mar 14 2006
4 comments
1,354 views