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

On 21 Jan 2002 09:26:25 -0800, bob_chauvin_at_yahoo.com (R.Chauvin) wrote:

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

Sure, Oracle 8i is not certified for win XP, not guaranteed to work, and hence not supported. I don't know why people are even trying to run this uncertified combination. Winsucks programs are never 100 % downwards compatible.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jan 21 2002 - 17:10:12 CST