How can i run pl/sql in express edition??? plss help me.
748736Jan 24 2010 — edited Jan 26 2010I am trying to run pl/sql statements in oracle express edition 10g but it can not run! what can i do? which program should i download to run pl/sql???
pls help me!
thanks.
Code:
---------------------------------------------------------------------------------
SET SERVEROUTPUT ON
DECLARE
v_count NUMBER(2) := 1;
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE(v_count);
v_count := v_count + 2;
EXIT WHEN v_count > 10;
END LOOP;
END;
---------------------------------------------------------------------------------
Error code:
ORA-00922: missing or invalid option
The version:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Edited by: user8944100 on 24.Oca.2010 12:31
Edited by: user8944100 on 24.Oca.2010 12:37