compilation error

From: <kal121_at_yahoo.com>
Date: Mon, 07 Dec 1998 22:03:23 GMT
Message-ID: <74hjb9$b5u$1@nnrp1.dejanews.com>

Why doesn't Oracle like the following SQL statement? Is there an easier way to do this? I don't want to have to re-type this scipt everytime I need it. Is there a way to "parameterize" a script if this doesn't work? Thanks!

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 Mon Dec 07 1998 - 16:03:23 CST