PL/SQL (MOSC)

MOSC Banner

Errors when trying to wrap a create package script

edited Oct 27, 2010 1:50AM in PL/SQL (MOSC) 3 commentsAnswered
Hi there.

I am trying to wrap a Sql script, basically a CREATE PACKAGE BODY script.

I am running the wrap command from UNIX using the "edebug=wrap_new_sql" parameter.

This is still failing when the PL/SQL processor encounters a CASE statement in the select list of one of my cursors in an internal procedure to the package.

Error message:

PSU(103,1,138,11):Encountered the symbol "CASE" when expecting one of the following:

   ( - + mod not null others <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> avg
   count current exists max min prior sql stddev sum variance
   cast <a string literal with character set specification>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center