Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> problems compiling procedure
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