Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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...

Error trying to Create a Procedure on Oracle 8i and Windows XP ORA-06544:PL/SQL:internal error...

From: R.Chauvin <bob_chauvin_at_yahoo.com>
Date: 21 Jan 2002 09:26:25 -0800
Message-ID: <e13ba62b.0201210926.29739dc9@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US