| create package [message #352] |
Wed, 06 February 2002 10:20  |
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  |
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 |
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)');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
