Compiere on Oracle XE

For those who ventured too far - just hope they know their way back :)

Moderator: neilg

Compiere on Oracle XE

Postby harinder_kaur » Mon Mar 20, 2006 3:12 pm

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
harinder_kaur
 
Posts: 12
Joined: Fri Jul 29, 2005 2:54 pm
Location: INDIA

Postby sweet_hell » Tue Apr 18, 2006 6:03 pm

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
 
Posts: 6
Joined: Tue Feb 28, 2006 10:54 pm
Location: Tunisia

Postby sweet_hell » Tue Apr 18, 2006 6:10 pm

after a little round on this page :

http://asktom.oracle.com/pls/ask/f?p=49 ... 4225010478

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
sweet_hell
 
Posts: 6
Joined: Tue Feb 28, 2006 10:54 pm
Location: Tunisia


Return to Strictly Technical

Who is online

Users browsing this forum: No registered users and 1 guest

cron