Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Problem with SQLPlus Syntax - ORA-00922 Missing or invalid option

Avatar of MyDanes
MyDanes asked on
Oracle Database
1 Comment1 Solution4609 ViewsLast Modified:
SQL> @invalid_results.txt
alter PACKAGE BODY SYS.DBMS_REPCAT_AUTH compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY SYS.DBMS_REPCAT_RGT_CUST compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY SYS.DBMS_REPCAT_UTL4 compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY SYS.LTADM compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY SYS.LTRIC compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY SYS.LT_EXPORT_PKG compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter VIEW SYS._ALL_REPCOLUMN_GROUP compile
               *
ERROR at line 1:
ORA-00911: invalid character


alter VIEW SYS._ALL_REPCONFLICT compile
               *
ERROR at line 1:
ORA-00911: invalid character


alter VIEW SYS._ALL_REPGROUPED_COLUMN compile
               *
ERROR at line 1:
ORA-00911: invalid character


alter VIEW SYS._ALL_REPPARAMETER_COLUMN compile
               *
ERROR at line 1:
ORA-00911: invalid character


alter VIEW SYS._ALL_REPRESOLUTION compile
               *
ERROR at line 1:
ORA-00911: invalid character



Warning: Procedure altered with compilation errors.

alter PACKAGE BODY SYSADM.BILLING_APPLICATION compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option



Warning: View altered with compilation errors.


Warning: View altered with compilation errors.


Warning: Procedure altered with compilation errors.


Warning: Type altered with compilation errors.


Warning: View altered with compilation errors.

alter PACKAGE BODY OAS_PUBLIC.HTF compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY OAS_PUBLIC.OWA compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY OAS_PUBLIC.OWA_COOKIE compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


alter PACKAGE BODY OAS_PUBLIC.OWA_CUSTOM compile
                   *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> spool off;
ASKER CERTIFIED SOLUTION
Avatar of Sujith
SujithFlag of United Kingdom of Great Britain and Northern Ireland imageData Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers