Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating a dump of all variable values
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- mixedbag
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
ORA-12154 error
yep that variable is also correctly set.- mixedbag
- Post #5
- Forum: Oracle: All versions
-
ORA-12154 error
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.- mixedbag
- Post #3
- Forum: Oracle: All versions
-
ORA-12154 error
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=...- mixedbag
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
create command in stored procedure
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...- mixedbag
- Thread
- Replies: 2
- Forum: Oracle: All versions
