I changed it, and it still complains about it.
Here is another example:
cc_dev@DIS1> @cmdr/v2_5c/wrapped/cc6014
Sequence dropped.
Elapsed: 00:00:00.01
Sequence created.
Elapsed: 00:00:00.00
Warning: Package created with compilation errors.
Elapsed: 00:00:00.03
Errors for PACKAGE CC_JOBS_PKG:
LINE/COL ERROR
-------- --------------------------
80/70 PLS-00103: Encountered the symbol "" when expecting one of the
following:
<an identifier> <a double-quoted delimited-identifier>
current
The symbol "" was ignored.
Warning: Package Body created with compilation errors.
Elapsed: 00:00:00.03
Errors for PACKAGE BODY CC_JOBS_PKG:
LINE/COL ERROR
-------- --------------------------
273/20 PLS-00103: Encountered the symbol "" 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
pipe
The symbol "" was ignored.
cc_dev@DIS1> @cmdr/v2_5c/all_sqls/cc601
Sequence dropped.
Elapsed: 00:00:00.01
Sequence created.
Elapsed: 00:00:00.00
Package created.
Elapsed: 00:00:00.06
No errors.
Package body created.
cc_dev@DIS1> @lst_src2 CC_JOBS_PKG 70 90
old 3: where name like '&1%'
new 3: where name like 'CC_JOBS_PKG%'
old 4: and line > &2 and line < &3
new 4: and line > 70 and line < 90
LINE TEXT
----- --------------------------
71 p_prj_id NUMBER DEFAULT NULL,
72 p_client_id NUMBER DEFAULT NULL,
73 p_job_name VARCHAR2 DEFAULT NULL,
74 p_job_desc VARCHAR2 DEFAULT NULL,
75 p_job_args VARCHAR2 DEFAULT NULL,
76 p_job_submittedby VARCHAR2 DEFAULT NULL,
77 p_job_action VARCHAR2 DEFAULT NULL,
78 p_job_inpath VARCHAR2 DEFAULT NULL,
79 p_job_outpath VARCHAR2 DEFAULT NULL,
80 p_job_status VARCHAR2 DEFAULT NULL,
81 p_job_remark VARCHAR2 DEFAULT NULL,
82 p_studyid VARCHAR2 DEFAULT NULL,
83 p_domain VARCHAR2 DEFAULT NULL,
84 p_schema VARCHAR2 DEFAULT NULL,
85 p_start_time DATE DEFAULT NULL,
86 p_end_time DATE DEFAULT NULL,
87 p_run_count NUMBER DEFAULT NULL,
88 p_db_user VARCHAR2 DEFAULT USER,
89 p_os_user VARCHAR2 DEFAULT sys_contex
t('USERENV','OS_USER'),
71 CLIENT_ID,
72 JOB_NAME,
73 JOB_DESC,
74 JOB_ARGS,
75 JOB_SUBMITTEDBY,
76 JOB_ACTION,
77 JOB_INPATH,
78 JOB_OUTPATH,
79 JOB_STATUS,
80 JOB_REMARK,
81 STUDYID,
LINE TEXT
----- --------------------------
82 DOMAIN,
83 SCHEMA,
84 START_TIME,
85 END_TIME,
86 RUN_COUNT,
87 DB_USER,
88 OS_USER
89 ) VALUES (
38 rows selected.
cc_dev@DIS1> @lst_src2 CC_JOBS_PKG 270 290
old 3: where name like '&1%'
new 3: where name like 'CC_JOBS_PKG%'
old 4: and line > &2 and line < &3
new 4: and line > 270 and line < 290
LINE TEXT
----- --------------------------
271 EXECUTE IMMEDIATE v_sql INTO g_num USING p_job_id;
272 IF g_num <> 1 THEN
273 v_sta := 'ERR';
274 v_msg := 'ERR('||v_prg||'): '||TO_CHAR(g_num)||' record for key ';
275 v_msg := v_msg||p_job_id;
276 echo(v_msg, 1);
277 GOTO pupd_fail;
278 END IF;
279
280 -- only update if the variable is not null
281 OPEN c1 FOR
282 SELECT * FROM cc_jobs WHERE JOB_ID = p_job_id;
283 LOOP
284 FETCH c1 INTO r1;
285 EXIT WHEN c1%NOTFOUND;
286 END LOOP;
287 CLOSE c1;
288 -- 0: if input is not null, we use input;
289 -- if null, then we do not update
19 rows selected.
Main Topics
Browse All Topics





by: sdstuberPosted on 2008-05-05 at 07:45:41ID: 21500394
I "shouldn't" matter, but try initializing v_msg to NULL instead of ''
Functionally it'll be the same thing, but if the parser is complaining about it then try circumventing it.