First of all, thanks a lot for this great project. I am
starting to play around with it and it looks very good.
I just wanted to let you know the problem I found when
I was getting the following error:
ORA-00955 name is already used by an existing object
I could not find anything wrong in the way of using those
procedures so I started to go deeper and deeper in the
code until I found the problem in
The code for this procedure is the following:
PROCEDURE execute_ddl (stmt VARCHAR2) IS --/* Ignore Oracle7 code! fdbk PLS_INTEGER; cur PLS_INTEGER := DBMS_SQL.open_cursor; --Ignore Oracle7 code! */ BEGIN --/* Use 8i code! */ EXECUTE IMMEDIATE stmt; --/* Use 8i code! */ --/* Ignore Oracle7 code! DBMS_SQL.parse (cur, stmt, DBMS_SQL.native); fdbk := DBMS_SQL.EXECUTE (cur); DBMS_SQL.close_cursor (cur); --Ignore Oracle7 code! */ EXCEPTION WHEN OTHERS THEN RAISE; END;
stmt parameter is a
CREATE TABLE statement,
it will fail raising the error:
ORA-00955 name is already
used by an existing object because it is trying to
create the table twice.
Just leaving the
EXECUTE statement works perfectly
with my Oracle 9i database.
Hope this comment helps to make the utPLSQL
PD: my email is: email@example.com