I'm getting an ORA-06550 error with submessage PLS-00103, which is objecting to the word 'INSERT' as it is expecting a ':[email protected]
%;.' 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: ":[email protected]
%;" 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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.