problems compiling procedure

From: <kal121_at_yahoo.com>
Date: Tue, 08 Dec 1998 13:47:05 GMT
Message-ID: <74jako$pji$1@nnrp1.dejanews.com>

Does anyone know why this doesn't work? And how can I get around this? Thanks, KL

SQL> PROCEDURE get_plan(stmt_id VARCHAR2) IS 2 3 BEGIN 4 5 SELECT 6 LPAD(' ',2*Level)||Operation||' '||Options||' '||Object_Name Execution_Plan 7 FROM plan_table 8 WHERE Statement_Id = 'stmt_id' 9 CONNECT BY PRIOR ID = Parent_ID and Statement_ID = 'stmt_id' 10 START WITH ID=0; 11 12 END; 13 / PROCEDURE get_plan(stmt_id VARCHAR2) IS * ERROR at line 1: ORA-00900: invalid SQL statement

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 08 1998 - 07:47:05 CST