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
yes I am starting sqlplus in the way mentioned above.
I have now created a sqlnet.ora with defult domain set to workgroup
the oracle_home is set to my oracle path /oracle/OraHome1
the oracle_sid is set to my instance po.
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.