So it doesn't work but what is the error?
Tell us more.
--
Michel
ykhlef Mourad <ykhlef_at_yahoo.fr> a écrit dans le message : 38F31E29.434D79B6_at_yahoo.fr...
> Hi,
>
> Here is my dynamic storage procedure exec.
>
> CREATE OR REPLACE PROCEDURE exec(theString in varchar2) as
> cursor_name INTEGER;
> rows_processed INTEGER;
> BEGIN
> cursor_name := dbms_sql.open_cursor;
> dbms_sql.parse(cursor_name, theString, dbms_sql.v7);
> rows_processed := dbms_sql.execute(cursor_name);
> dbms_sql.close_cursor(cursor_name);
> EXCEPTION
> when others then
> dbms_sql.close_cursor(cursor_name);
> END exec;
> /
>
> Probleme
> -------------
>
> The command
> execute exec('create table myT(a number(34))');
>
> works in SYS schema and does not in a user Schema :
>
> Note that the command
> execute exec('drop table client');
> works in a user schema
>
>
> Thank you in advance
> Mourad
>
>
Received on Tue Apr 11 2000 - 00:00:00 CDT
