I have a stored procedure that use the dbms_sql package in order to create or alter database users from within Forms Designer version 4.5.
This is like :
PROCEDURE CHANGE_PASSWORD IS
CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;
dbms_sql.parse(CURSOR_NAME,'ALTER USER joseph IDENTIFIED BY "JOSEPH"',DBMS_SQL.V7);
RET := DBMS_SQL.EXECUTE(CURSOR_NAME);
When I call the stored procedure from within the forms Designer 4.5 the execution of the above block is interrupted in the "dbms_sql.parse..." statement.The last statement "DBMS_SQL.EXECUTE(CURSOR_NAME)" is not executed and the password didn't change.
No error message or error code is generated.
N.B.:If I call the procedure from within SQL*PLUS ,the procedure work very well.
Please help to resolve this problem?
Thanks a lot.