I got ORA-03001: unimplemented feature

From: TL <lamkin_at_tiac.net>
Date: 1998/03/11
Message-ID: <01bd4d42$ad5bd960$a94c3dd1@l58cb9>#1/1

Ok, so I could not do it in a trigger because of the implicit COMMIT. Fine, now I try it from a straight stored procedure and I get the message above ORA-03001: unimplemented feature.

The code below is trying to issue the GRANT statement, but fails. I don't believe that this is unimplemented in version 7.3?

PROCEDURE ChangePassword (userID IN VARCHAR2) IS

	cid integer;
	userPassword varchar2(15);
	sqlCommand varchar2(255) := 	'GRANT CONNECT TO '
				||	userID 
				||	'IDENTIFIED BY '
				||	'x' || userPassword;
BEGIN
	SELECT cur_pswd_cde INTO userPassword FROM tbw006_usr WHERE id = userID;  


	DBMS_OUTPUT.PUT_LINE ('stored procedure gets password ' || userPassword);
 	cid := DBMS_SQL.OPEN_CURSOR;
 	DBMS_SQL.PARSE(cid, sqlCommand, dbms_sql.v7);
	DBMS_SQL.CLOSE_CURSOR(cid);
  	DBMS_OUTPUT.PUT_LINE ('we finished the stored procedure');

END; TL <lamkin_at_tiac.net> wrote in article
<01bd4d39$6f3598a0$054f3dd1_at_l58cb9>...
> I have tried issuing a GRANT statement in both a trigger and in a stored
> procedure, but can't get past the compile phase. I am hoping to change
 the
> user's Oracle password via PL/SQL to keep that password in synch with a
> password in our application. Possible?
>
> Todd
>
Received on Wed Mar 11 1998 - 00:00:00 CST