Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Error trying to Create a Procedure on Oracle 8i and Windows XP ORA-06544:PL/SQL:internal error...
I get the following when trying to create a stored procedure on my XP
box, running Oracle 8.1.7.
[Oracle][ODBC][Ora]ORA-06544:PL/SQL:internal error, arguments:[2603],[],[],[],[],[],[],[] ORA-06553: PLS-707: unsupported construct or internal error [2603]
Tables and sequences can be created without error. Even the most simple procedure fails with this error, for example:
create or replace PROCEDURE VIC_RESET_LOAD_PRODUCT_test(PIN_CATALOG_ID
NUMBER) IS
BEGIN
DELETE FROM VIC_PRODUCT_IMPORT
WHERE CATALOG_ID = PIN_CATALOG_ID;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001, 'ORA-'||TO_CHAR(SQLCODE)||':
'||SQLERRM);
END;
This PL/SQL works to create a procedure when connected to my Oracle
server at the office.
Any ideas? Received on Mon Jan 21 2002 - 11:26:25 CST