Pass sql into pl/sql and create RMAN duplicate script.

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I'm new to pl/sql and I'm trying to write a script that will generate some RMAN commands to do a database clone.

I want to able to run the script and it prompt me for variables to be used in the script.

I've done some research but I've been unable to find any examples of how to do this.

Basic script is (there would obviously be a lot more to the final script):

declare

dbname varchar2(9) := &dbname;

BEGIN
DBMS_OUTPUT.ENABLE(2000);
DBMS_OUTPUT.PUT_LINE(' DUPLICATE TARGET DATABASE TO '|| dbname ||';');
end;
/

Gives me:

Enter value for dbname: ORCL4
old 3: dbname varchar2(9) := &dbname;
new 3: dbname varchar2(9) := ORCL4;
dbname varchar2(9) := ORCL4;
*
ERROR at line 3:
ORA-06550: line 3, column 24:
PLS-00201: identifier 'ORCL4' must be declared
ORA-06550: line 3, column 9:
PL/SQL: Item ignored
ORA-06550: line 7, column 66:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 7, column 9:
PL/SQL: Statement ignored

Thanks,

Your Answer:

Login to answer

Other forums

Upload Code Help
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t

ORA-01017: invalid username/password; logon denied
Dear All,

I am facing problem in taken backup from db13 it comes up with the following l

onclick problem
I have <input type="text" name="message">
<a href=page2.