| ora-06550 error after execute a pl/sql block? [message #392735] |
Thu, 19 March 2009 02:02  |
misr_sony
Messages: 3
Registered: March 2009
|
Junior Member |
|
|
Hi Guys,
since yesterday i use the toad version 9.0, but it doesn't works.
If i execute in this new version an pl/sql block the following error is shown:
ORA-06550: line 7, column 30:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
the funny is, if i marking the whole pl/sql block, all works fine and the output is correct!
there are any settings that i have to check?
thanks for your help.
cheers,
mike
|
|
|
|
|
|
| Re: ora-06550 error after execute a pl/sql block? [message #392748 is a reply to message #392735] |
Thu, 19 March 2009 03:25  |
misr_sony
Messages: 3
Registered: March 2009
|
Junior Member |
|
|
DECLARE
CURSOR c_data IS
--
select *
from generic_match_wl
where organization = 'EMI'
and status = '0'
and ref_key1 is null
and type = 'RELATED'
and rownum < 60000
;
CURSOR c_get_uai ( cv_asset_name VARCHAR2 ) IS
select upload_asset_id
from asset_master_data
where organization_grp = 'EMI'
and asset_content_type = 'AUDIO_REL'
and asset_security = 'STORED'
and contains(asset_name,'{'||cv_asset_name||'}') > 0
;
v_get_uai c_get_uai%ROWTYPE;
v_succ NUMBER :=0;
v_err NUMBER:=0;
v_checked NUMBER:=0;
--
BEGIN
--
FOR v_data IN c_data LOOP
--
OPEN c_get_uai (v_data.filename);
FETCH c_get_uai INTO v_get_uai.upload_asset_id;
--
v_checked := v_checked + 1;
--
IF ( c_get_uai%FOUND ) THEN
-- DBMS_OUTPUT.PUT_LINE('Upload_asset_id found for '||v_data.filename||' ('||v_get_uai.upload_asset_id);
--
UPDATE generic_match_wl
SET ref_key1 = v_get_uai.upload_asset_id, mod_usr = 'FGIE', mod_dat = sysdate, status = '1'
WHERE organization = 'EMI'
AND type = 'RELATED'
AND product_id = v_data.product_id
--AND track_id = v_data.track_id
--AND side_id = v_data.side_id
AND filename = v_data.filename;
--
v_succ := v_succ + 1;
--
ELSE
--
UPDATE generic_match_wl
SET status = 'E', remark = 'related file not found', mod_usr = 'FGIE', mod_dat = sysdate
WHERE organization = 'EMI'
AND type = 'RELATED'
AND product_id = v_data.product_id
AND track_id = v_data.track_id
AND side_id = v_data.side_id
AND filename = v_data.filename;
--
v_err := v_err + 1;
--
END IF;
COMMIT;
--
CLOSE c_get_uai;
--
END LOOP;
DBMS_OUTPUT.PUT_LINE(v_checked||' lines checked');
DBMS_OUTPUT.PUT_LINE(v_succ||' lines set to status 1');
DBMS_OUTPUT.PUT_LINE(v_err||' lines set to status E');
--
END;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
