Re: Create Table in PL/SQL

drfuller_at_wsicorp.com (Donald Fuller) writes:

> I am trying to create temporary tables in my stored procedures and I
>am finding that I cannot create, drop or truncate tables. Is this
>functionality not available in PL/SQL?
 

>Any suggestion on how I can ? I listed the error message I am receiving.

To perform DDL operations in PL/SQL, you must use the dbms_sql package. Check the manual for usage. The example below will create a test table using dbms_sql.

declare
  handle integer;
  sql_stmt varchar2(142);
begin
  handle := dbms_sql.open_cursor;
  sql_stmt := 'create table test (a1 number) tablespace user_data';   dbms_sql.parse(handle, sql_stmt, dbms_sql.native);   dbms_sql.close_cursor(handle);
end;
/

--

Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.