pomiu
asked on
SQLPlus to run a .sql file
Dear experts,
I want to run a .sql which contains some sql code as shown.
However, when I run sqlplus command in windows command prompt.
The sqlplus can successfully login but hold to wait me to input for more?
Mysqlplus command:
"sqlplus username/password@somewher e @c:\oracle\replicate.sql"
I can only quit by pressing Ctrl+C, and I check the result that my script didn't run successfully.
Did my code in .sql missing something?
Many thanks
I want to run a .sql which contains some sql code as shown.
However, when I run sqlplus command in windows command prompt.
The sqlplus can successfully login but hold to wait me to input for more?
Mysqlplus command:
"sqlplus username/password@somewher
I can only quit by pressing Ctrl+C, and I check the result that my script didn't run successfully.
Did my code in .sql missing something?
Many thanks
declare rc binary_integer;
begin rc := sys.dbms_defer_sys.push(destination=>'DBBK', stop_on_error=>FALSE, delay_seconds=>0, parallelism=>0);
end;
sqlpluserror.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.techonthenet.com/oracle/questions/script.php
ASKER
Many thanks.