Advertisement

05.05.2008 at 06:58AM PDT, ID: 23376391
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.6

Wrapped package would not compile while unwrapped compiles fine

Asked by geotiger in PL / SQL, Oracle 10.x

Tags: , , , , ,

I have a cc_clients_pkg which can be compiled without error but it will give me the following error after I wrapped it using Oracle wrap utility:

Errors for PACKAGE BODY CC_CLIENTS_PKG:

LINE/COL ERROR                                                                  
-------- -----------------------------------------------------------------      
364/6    PLS-00103: Encountered the symbol "" when expecting one of the        
         following:                                                            
         begin case declare 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 pipe                    
         The symbol "" was ignored.                                            
                                                       

Here I am going to compile it without wrapping and to show you the codes around the error line:

cc_dev@OWB1> @cmdr/v2_5c/all_sqls/cc6004_clients_pkg.sql

Sequence dropped.

Elapsed: 00:00:00.08

Sequence created.

Elapsed: 00:00:00.05

Package created.

Elapsed: 00:00:00.35
No errors.

Package body created.

Elapsed: 00:00:00.33
No errors.
cc_dev@OWB1> @lst_src2 CC_CL 350 380
old   3: where name like '&1%'
new   3: where name like 'CC_CL%'
old   4: and line > &2 and line < &3
new   4: and line > 350 and line < 380

 LINE TEXT
----- --------------------------------------------------------------------------
  351 PROCEDURE p_sel (
  352   p_key        IN     cc_clients.CLIENT_ID%TYPE DEFAULT NULL,
  353   p_whr        IN     VARCHAR2 DEFAULT NULL,
  354   p_out_num       OUT NUMBER,    -- out status number
  355   p_out_msg       OUT VARCHAR2,  -- out message
  356   p_rec           OUT rst_refcur,
  357   p_lck        IN     NUMBER DEFAULT 0 -- lock record: 0(no) 1(yes)
  358 ) IS
  359   v_prg VARCHAR2(100) := g_pkg||'.p_sel';
  360   v_sta VARCHAR2(10)  := 'OK';
  361   v_whr VARCHAR2(1000);
  362   v_msg VARCHAR2(200) := '';
  363   v_sql VARCHAR2(2000);
  364 BEGIN
  365   echo(' - '||v_prg, 1);
  366   p_out_num := 0;
  367   p_out_msg := 'OK';
  368   -- check input variables
  369   IF p_key IS NULL AND p_whr IS NULL THEN
  370     v_msg := 'ERR('||v_prg||'): no input for p_key or p_whr';
  371     raise_application_error(-20001,v_msg);
  372   END IF;
  373
  374   IF p_key IS NULL THEN
  375     v_whr := ' WHERE '||p_whr;
  376   ELSE
  377     v_whr := ' WHERE client_id = '||p_key;
  378   END IF;
  379   -- check record existence

29 rows selected.



Start Free Trial
[+][-]05.05.2008 at 07:45AM PDT, ID: 21500394

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.06.2008 at 02:32PM PDT, ID: 21511264

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.18.2008 at 08:20AM PDT, ID: 22252691

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.18.2008 at 08:21AM PDT, ID: 22252700

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.18.2008 at 08:24AM PDT, ID: 22252721

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.18.2008 at 08:25AM PDT, ID: 22252736

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.05.2008 at 02:10PM PDT, ID: 22403859

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]09.10.2008 at 08:19PM PDT, ID: 22445817

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PL / SQL, Oracle 10.x
Tags: Oracle, Oracle database server, 10.2.0.3, wrapped package, PL/SQL, 10.2.0.3
Sign Up Now!
Solution Provided By: Computer101
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628