COPY Command (Oracle 9) 1

[framework]

Hi guys,

ORACLE 9i is the environment.
Guys,

Is there any way you can execute sql*plus commandd in anonymous PL/SQL block ?

(through the EXECUTE IMMEDIATE ) ?

Thanks

 

[SantaMufasa]

Frame,

First, could you please clarify how your thread title, "COPY Command (Oracle 9)" relates to your actual questions?

Second, PL/SQL is able to process PL/SQL commands, functions, and procedures, and passes on SQL commands to the Oracle Server for execution. PL/SQL does not support execution of (even via "EXECUTE IMMEDIATE&quot any strictly SQL*Plus commands.

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:13 (23Dec03) GMT, 11:13 (23Dec03) Mountain Time)

 

[framework]

Santa,

Thank you for your quick help.
I did vote for you

 

[NITIN27]

Try also

FORMS_DDL COMMAND AS IT ISSUES AN IMPLICIT COMMIT

EG.
FORMS_DDL('CREATE USER A IDENTIFIED BY A');
FORMS_DDL('GRANT CONNECT,RESOURCE TO A');

 

[SantaMufasa]

Nitin,

Was your post for this thread? If so, help me out...How does your post relate to Framework's thread?

Mufasa
(aka Dave of Sandy, Utah, USA @ 20:10 (25Dec03) GMT, 13:10 (25Dec03) Mountain Time)