Re: Stored Procedures

Steven,

You can perform DDL in pl/sql. I use the DBMS_UTILITY.EXEC_DDL Statement...example....

SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('CREATE INDEX sms_event_index ON a_event_sms event_id) TABLESPACE TEMP');

scott felten

Steven R Fuller wrote in message <37DEDC48.B8AEDFAC_at_doitnow.com>...
>Ok , Let me clarify my stored procedures questions.
>
>When I execute a create or replace procedure, I get a procedure created
>with compilation errors,
>
>However when I break out the individual code ie:
>
>drop table s_emp
>;
>
>Create table s_emp
>(
> FName VARCHAR2(25)
> ,LNAME VARCHAR2(25)
>)
>;
>
>INSERT INTO S_EMP
>(FNAME, LNAME)
>VALUES('JOHN', 'DOE')
>;
>
>This works fine
>
>When I create a proc like this I get an error
>
>create procedure emp_load
>is
>Begin
>drop table s_emp
>;
>
>Create table s_emp
>(
> FName VARCHAR2(25)
> ,LNAME VARCHAR2(25)
>)
>;
>
>INSERT INTO S_EMP
>(FNAME, LNAME)
>VALUES('JOHN', 'DOE')
>;
>
>end emp_load;
>
>NOW I GET THE ERRORS
>
Received on Wed Sep 15 1999 - 00:00:00 CEST