Home » SQL & PL/SQL » Client Tools » ora-06550 error after execute a pl/sql block?
ora-06550 error after execute a pl/sql block? [message #392735] Thu, 19 March 2009 02:02 Go to next message
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 #392747 is a reply to message #392735] Thu, 19 March 2009 03:23 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
It's hard to tell for us if we can't see the pl/sql code you have tried.

Could you post the pl/sql block you tried to execute?

Use code tags around the code ( the button that looks like '{..}' )
Re: ora-06550 error after execute a pl/sql block? [message #392748 is a reply to message #392735] Thu, 19 March 2009 03:25 Go to previous messageGo to next message
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;
Re: ora-06550 error after execute a pl/sql block? [message #392752 is a reply to message #392748] Thu, 19 March 2009 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Use code tags around the code ( the button that looks like '{..}' )


Re: ora-06550 error after execute a pl/sql block? [message #392754 is a reply to message #392735] Thu, 19 March 2009 03:49 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
I know that there are different ways to "execute" statements in TOAD ( CTRL-ENTER; F9; that cute green triangle button )

How do you "execute" the pl/sql block?
Re: ora-06550 error after execute a pl/sql block? [message #392757 is a reply to message #392735] Thu, 19 March 2009 03:55 Go to previous message
misr_sony
Messages: 3
Registered: March 2009
Junior Member
i don't see any triangle button Smile

i execute this block with "CTRL + ENTER".
so i execute all sql's Razz
Previous Topic: TOAD Block
Next Topic: Development Tools (3 posts merged by bb)
Goto Forum:
  


Current Time: Mon Dec 05 14:55:33 CST 2016

Total time taken to generate the page: 0.08755 seconds