Home » SQL & PL/SQL » SQL & PL/SQL » create package
create package [message #352] Wed, 06 February 2002 10:20 Go to next message
Shmuli
Messages: 3
Registered: January 2002
Junior Member
I am creating a package in SQL* and it tells me that it was created with compilation errors and when I type show errors it says PLS-00103 encountered the symbol "CREATE".
Can you help me figure out what the problem is?
Thank You Very Much -- aany help is greatly appreciated!!
Shmuli
Re: create package [message #354 is a reply to message #352] Wed, 06 February 2002 13:30 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
i think u r using ddl command inside procedure.
DDL commands are not allowed inside procedures. for that, you have to use dynamic sql.

create or replace procedure p1 is
begin
execute immediate 'create ....';
end;
Re: create package [message #361 is a reply to message #352] Wed, 06 February 2002 22:04 Go to previous message
Anatol
Messages: 15
Registered: January 2002
Junior Member
This is because you must run you create command as dinamic sql so make this one:
a) try this command:
execute immediate 'create some_table(r1 number , r2 varchar2)';
b)
dbms_sql('create some_table(r1 number , r2 varchar2)');
Previous Topic: HOW TO GET CONTEXT OF AN EXISTS STORED PROCEDURE
Next Topic: PL-SQL set object or selection from table variable
Goto Forum:
  


Current Time: Mon Sep 27 16:55:01 CDT 2021