Q
Problem solve Get help with specific problems with your technologies, process and projects.

Cause of ORA-06550 error

I'm getting an ORA-06550 error with submessage PLS-00103, which is objecting to the word 'INSERT.' I initially thought this would be a code issue but when I backed the database up and imported it to a standard Oracle-built database the problem went away. Are there any database configuration options that can cause an ORA-06550 error?

I'm getting an ORA-06550 error with submessage PLS-00103, which is objecting to the word 'INSERT' as it is expecting a ':+.@%;.' I initially thought this would be a code issue but when I backed the database up and imported it to a standard Oracle-built database the problem went away. My question is are there any database configuration options that can cause an ORA-06550 error?
The ORA-6550 error is simply telling you which line of code is causing the error to be thrown. So this error is not the cause of your problem, just a pointer to the actual problem. The PLS-103 error is the true cause of your problem. The PLS-103 error is saying "Encountered the symbol "%s" when expecting one of the following." From your description, it looks like your PL/SQL block is expecting one of the following: ":+.@%;" instead of INSERT. Typically, this means you did not include a semicolon to terminate the command before the INSERT statement.

Without seeing your exact PL/SQL code, I am not sure why your code worked with a new database. But there are no...

configuration options which can cause the ORA-6550 as this error is only in response to another error.

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close