FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-00000 Through ORA-09989 / ORA-06550: line num, column num: str ora error code 6550 / Latest Posts

RE: ORA-06550: line num, column num: str ora error code 6550

Admin — Mon, 14 Jun 2010 15:53:54 GMT

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

RE: ORA-06550: line num, column num: str ora error code 6550

Admin — Mon, 14 Jun 2010 15:52:56 GMT

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

RE: ORA-06550: line num, column num: str ora error code 6550

Admin — Mon, 14 Jun 2010 15:51:22 GMT

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.

Solution

Step 1: Change your application to generate inline SQL instead of stored procedures via the Application Wizard.

Step 2: Build and run your application.

RE: ORA-06550: line num, column num: str ora error code 6550

Admin — Mon, 14 Jun 2010 15:48:53 GMT

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

RE: ORA-06550: line num, column num: str ora error code 6550

Admin — Mon, 14 Jun 2010 15:47:22 GMT

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 occurred

ORA-06550:line string, column string:string

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

ORA-06550: line num, column num: str ora error code 6550

Admin — Mon, 14 Jun 2010 15:46:33 GMT

Ora Error Code ORA-06550: line num, column num: str

Error:	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.