 Posted 6/14/2010 3:46:33 PM
|
|
|
|
Ora Error Code ORA-06550: line num, column num: strError: | ORA-06550: line num, column num: str | Cause: | You tried to compile a block of PLSQL code, but a compilation error occurred. | Action: | The options to resolve this Oracle error are: - Refer to the line and column numbers (in the error message) to find the compilation error and correct it. Then try recompiling your code.
|
|
|
|
Posted 6/14/2010 3:47:22 PM
|
|
|
|
ORA-06550, ORA 6550 error is a generic error that indicates the line number at which the error has occured. This error is followed by a descriptive message that actually points to the type of oracle error that has occurredORA-06550:line string, column string:stringORA-06550 Cause: A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block where the error occurred. ORA-06550 Action: Refer to the following PL/SQL messages for more information about the error. The ORA-06550 error points to the location of the syntax error and this error is followed by a more descriptive message ORA-06550: line 14, column 27: PLS-00302: component 'MY_DATABASE' must be declared ORA-06550: line 14, column 12: PL/SQL:Statement ignored ORA-06550: line 12, column 2: PLS-00302: component 'MY_SITE' must be declared ORA-06550: line 12, column 4: PL/SQL:Statement ignored
|
|
|
Posted 6/14/2010 3:48:53 PM
|
|
|
|
ORA-06550 and ORA-06502 Two errors that continuously dog developers and dba's alike are ORA-06550 and ORA-06502. These are due to code issues within the PL/SQL that has been developed and a good explanation of the same is available at the locations below.
ORA-06550:line string, column string:string
ORA-06502 :Text: PL/SQL: numeric or value error
|
|
|
Posted 6/14/2010 3:51:22 PM
|
|
|
|
| You get this error when attempting to add, edit or delete a record in your application: Microsoft Internet Explorer Unable to create record. ORA-06550: line XX, column YY: PLS-0905: object ZZZ is invalid ORA-06550: line XX, column YY: PL/SQL: Statement ignored. 
This error occurs when your application’s stored procedures are not functioning properly at application run-time. SolutionStep 1: Change your application to generate inline SQL instead of stored procedures via the Application Wizard. Step 2: Build and run your application.
|
|
|
Posted 6/14/2010 3:52:56 PM
|
|
|
|
Resolving error ORA-06550- Digg This
- Stumble
- Delicious
I have problems when executing this sentence: SQL> executedbms_logmnr_d.build(options=>dbms_logmnr_d.store_in_redo_logs); BEGINdbms_logmnr_d.build(options=>dbms_logmnr_d.store_in_redo_logs); END; * ERROR at line 1: ORA-06550: line 1, column 50: PLS-00302: component 'STORE_IN_REDO_LOGS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored |
|
|
Posted 6/14/2010 3:53:54 PM
|
|
|
|
It appears that you have a permissions problem with
this package the the user that is running the package.
First, make sure that the user running the statement
above is given either the EXECUTE_CATALOG_ROLE role,
or is granted EXECUTE on DBMS_LOGMNR_D and DBMS_LOGMNR
directly.
Another thing to try is prepending the package with
the owner name, SYS.
executeSYS.dbms_logmnr_d.build(options=>SYS.dbms_logmnr_d.store_in_redo_logs);
Finally, if you are still having problems, sign on to
the system as SYS and run the following commands:
@?/rdbms/admin/dbmslmd.sql@?/rdbms/admin/dbmslm.sql
|
|
|
|