Home » SQL & PL/SQL » SQL & PL/SQL » expected symbol name is missing
expected symbol name is missing [message #37413] Wed, 06 February 2002 10:38 Go to next message
Bob
Messages: 49
Registered: March 1999
Member
When compiling a package body, the message "expected symbol name is missing" appears, but then it goes ahead and creates the package body. Anybody know what causes this?
Re: expected symbol name is missing [message #37419 is a reply to message #37413] Wed, 06 February 2002 22:08 Go to previous messageGo to next message
Anatol
Messages: 15
Registered: January 2002
Junior Member
Please explict your problem (whith that package for example)
Re: expected symbol name is missing [message #37427 is a reply to message #37413] Thu, 07 February 2002 03:35 Go to previous messageGo to next message
Bob
Messages: 49
Registered: March 1999
Member
I don't understand what you're asking for. In SQL*PLUS I run @x.pkb which is a standard text file containing my package body. It starts out CREATE OR REPLACE PACKAGE BODY, same as others that don't have this problem.
Re: expected symbol name is missing [message #37435 is a reply to message #37413] Thu, 07 February 2002 07:37 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
If there is an ampersand in your code - even in a COMMENT - SQL*PLUS will look at it as a substitution variable, and therefore will expect a symbol name, which of course it won't find.
Previous Topic: cursors and procedure problem,urgent!!
Next Topic: Equivilent to Explain
Goto Forum:
  


Current Time: Sat Sep 25 01:56:48 CDT 2021