| exception handling [message #358200] |
Mon, 10 November 2008 01:36  |
OracleDBA1
Messages: 7
Registered: November 2008
|
Junior Member |
|
|
hello everyone,
i am running the Following peice of code:
declare
dbname v$database.name%type;
instno v$instance.instance_number%type;
...........
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('the database name');
dbms_output.put_line(dbname);
.........
now i am not able to get the database name in my output.
SQL> /
the database name
PL/SQL procedure successfully completed.
How do I do this?Please Help!! 
Thanks A LOT in advance.
|
|
|
|
|
|
| Re: exception handling [message #358215 is a reply to message #358200] |
Mon, 10 November 2008 02:47  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
|
Do you actually select v$database.name into your variable dbname at any point? Your example does not make this clear.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
