red1.org

[harinder_kaur]

Hi1

I have imported compiere data on oracle XE . it gives the following errors

IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('META-INF/MANIFEST.MF', 0, 30, "
"0, 3, 484, 0); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('deployment/sqlj.ddr', 0, 30, 0"
", 9, 9478, 0); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Account', 0,"
" 29, 0, 4, 2234, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/BPartner', 0"
", 29, 0, 3, 1540, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Compiere', 0"
", 29, 0, 9, 8838, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Currency', 0"
", 29, 0, 6, 4689, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Invoice', 0,"
" 29, 0, 7, 6963, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Manufacturin"
"g', 0, 29, 0, 4, 2083, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Payment', 0,"
" 29, 0, 4, 3622, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/PaymentTerm'"
", 0, 29, 0, 7, 6494, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN :STATUS := DBMS_JAVA.START_IMPORT('org/compiere/sqlj/Product', 0,"
" 29, 0, 9, 8208, 1); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'DBMS_JAVA.START_IMPORT' must be declared
ORA-06550: line 1, column 11:

But my compiere is working ok.Please let me know the problems.

Thanks and Regards,
Harinder Kaur

[sweet_hell]

It must be a problem of jSQL .

I havn't installed Oracle XE yet but i'm not sure that it supports the jSQL statements. Anyway you can browse Oracle web site with the error code.
_________________
Best Regards,

Sweet Hell

[sweet_hell]

after a little round on this page :

http://asktom.oracle.com/pls/ask/f?p=4950:8:14558451919261707439::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:704225010478

It's a migration problem: it's due to oracle different versions so you have to follow the oracle's migration guide in the link above.
_________________
Best Regards,

Sweet Hell