Home > Ask the Oracle Experts > Database Backup and Recovery Questions & Answers > PLS-00103 errors
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

PLS-00103 errors

Brian Peasland EXPERT RESPONSE FROM: Brian Peasland

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 24 May 2007
I'm getting the following errors:
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one
of the following:
begin case declare else elsif end exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe

PLS-00103: Encountered the symbol "L_PREV_POS" when expecting one
of the following:

ERROR
-----------------------------------------------------------------
end not pragma final instantiable order overriding static
member constructor map

>
EXPERT RESPONSE
The errors above are syntax errors in PL/SQL code. Without seeing the code, I cannot determine the solution to the problem. But check your code's syntax.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
Database Backup and Recovery
How to recover a control file
The USING BACKUP CONTROLFILE clause in Oracle commands
Backup and recoveries of Oracle RAC 10gR2
How to use the OPatch Utility in Oracle
Backup and recovery of Oracle 10g with forgotten admin password
How to get history of modified data from Oracle databases
Export dump with files larger than 2 GB
What is Unix shell scripting?
Performing a backup with table locks
How to move data faster with a database link

Oracle PL/SQL
Oracle's free SQL Developer adds database migration tool
Confused about Oracle certification exams
ORA-01422 error when procedure returns more than one row
Calling procedure inside another procedure in anonymous block
How to import comma-delimited text file to Oracle table
Oracle updates Microsoft developer tools
PL/SQL do's and don't's: Five questions with Steven Feuerstein
Definition of force view
ORA-04082: NEW or OLD references not allowed in table level triggers
Oracle updates free Web development tool

Oracle error messages
ORA-12560 error with Oracle 10g Instant Client
Unable to view Oracle tables in NetBeans
IMP-00017 error message with Oracle import
Can't open database after failed backup export
Query on dblink returning ORA-12545 error
RMAN not working at command prompt
Unique constraint violations, "parent key not found" errors
Insufficient privileges error when creating stored procedure
IMP-00010 error with import from 10g to 9i
ORA-12801 error while loading seed data

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
PL/SQL  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsWebcastsWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts