Re: Error code: PLS-00103:

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Mon, 18 Oct 1999 15:02:41 -0700
Message-ID: <380B9901.CB44F6EF@vnl.nl>

Dan G wrote:

> platform: WINNT
> product: ORACLE8
> database version: 8.0.5
>
> client platform: Windows NT
> additional product: Oracle Designer
> Error code: PLS-00103: Encountered the symbol “&” when expecting one of
> the... comments: Please find below the details that I received when I
> generated WEB module from Designer tutorial:
> Finally the generation has been marked as completed but I’ve gotten from my
> browser (when trying to run the module) the error “The requested URL was not
> found.” for
> http://<machine:port>/<WebServerDAD>/plsql/publish_menu_on_the_web$.startup
>
> Does the final error or the warnings generate this behaviour ?.
>
> WebServer Generator (Windows 95/NT) : Version 2.0.24.0.0 - Production on Thu
> Oct 07 16:36:33 1999
> Copyright © 1995, 1998 Oracle Corporation. All rights reserved
> Generating Module ‘TUTORI0040’
> CGEN-03413 WARNING: Component PRICED_PRODUCTS: Module Component language
> ‘Developer/2000 Reports’ differs from module language
> CGEN-03344 WARNING: Component PRICED_PRODUCTS: First descriptor column is
> optional
> CGEN-03704 WARNING: Component PRICED_PRODUCTS: Combination of Module
> Implementation Name and DTU Alias too long
> CGEN-03333 WARNING: Table Usage PRICED_PRODUCTS.PP: Missing usage of primary
> key column ‘PP_ID’
> Generation of Module ‘TUTORI0040’ Successful
>
> Install generated packages in sa_at_designer_alias
>
> Package publish_menu_on_the_web$...
> Package created.
> No errors.
> Package publish_menu_on_the_web$priced...
> Package created.
> No errors.
> Package body publish_menu_on_the_web$...
> Package body created.
> No errors.
> Package body publish_menu_on_the_web$priced...
> Warning: Package Body created with compilation errors.
> Errors for PACKAGE BODY PUBLISH_MENU_ON_THE_WEB$PRICED:
> LINE/COL ERROR
> -------- -----------------------------------------------------------------
> 1218/89 PLS-00103: Encountered the symbol “&” when expecting one of the
> following:
> . ( ) , * @ & | = - + < / > in mod not range rem => ..
> an exponent (**) <> or != or ~= >= <= <> and or like between
> using is null is not || is dangling
>
> Generation Complete
>
> What to do ?.

Look at the error, and correct. Your package body is using an "&" where it's not supposed
to. That may also explain why the url is not found; the package body remains invalid.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Mon Oct 18 1999 - 17:02:41 CDT