Does anybody know of a way to dump a list of variables and their present values.
I know that you can examine variables when developing, but I want to be ale to log them to a file, when an error ocours once the program is in real use.
Thanks
Hi.
Oracle 9.2.0.1.0 on redhat 8.0
when starting the database or using sqlplus I get ORA-12154 : TNS: could not resolve service name.
Any ideas?
I have attached my tnsnames.ora and listener.ora below. both are located in $oracle_home/network/admin.
listener.ora:
LISTENER=
(DESCRIPTION=...
Is it possable to use the create command in a stored procedure as when I try this I get an error
Create or Replace Procedure Add_User
(p_name all_users.username%TYPE) AS
BEGIN
SELECT * from ALL_USERS;
CREATE TABLESPACE james
DATAFILE '/home/oracle/joy/oradata/joy/james01.dbf' size 10M...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.