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,
DB2 for z/OS, LUW, iSeries
Hello,
Server side $_SESSION
how does one keep the session completely server side. no cookies to the browser at all. i need this site to be cookie and jscript free.
Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named "color". The images are named the "color.jpg"I am attempting to loop through
default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?
insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text which will obviously be printed out client side at a later date. What my question is that is it
Weird problem with SELECT command..Help!
Hi!It seems I'm having a really weird problem with SQL SELECT command....I have table into a mySQL DB wich as 4 entry in it. I created the select command to retrieve the data and only 3 of the 4 entry
how to export excel file in same server
My first post - php newbie, so appreciate your support.I'm currently using headers to save web page as excel file.$filename="sms.xls";header("Pragma: public");header("Expires:
Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything.Code: <td class="row3"><input type="text"
Echo multiple lines of html code
Hi guys,I would like to know if there is a way to echo multiple lines of html codes. I intend to echo a form if a variable is set and nothing if it is not set. And right now, I echo each line of html
Data Function is Its Not working IN IE8
This is my first time to use formums. I hope i can get solution for this problem.