ORA-24315 on connession

Toad for Oracle - Beta
1

Latest beta, when connection to a db is made it returns twice this error:
ORA-24315
This happen with every Oracle version

Regards

Mauro

2

I think I know what that is, but can you get a spool SQL output, and let me know what database version that is? I know you said "Every" but it does not happen for me.

Thanks

John

3

Any version has this problem ( I tried 19.3, 11.2, 10.2 ), this is the spool output from connection:

-- Timestamp: 14:43:05.633
Connect: SYSTEM@
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
:id(VARCHAR[0],OUT)=
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
:RetVal(BOOLEAN,OUT)=
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido
-- ORA-24315: tipo di attributo non valido

-- Timestamp: 14:43:14.965
Connect: SYSTEM@

-- Session: SYSTEM@
-- Timestamp: 14:43:15.217
begin sys.dbms_application_info.set_module('TOAD background query session', '45875744,333254064,448322224'); end;

-- Session: SYSTEM@
-- Timestamp: 14:43:15.872
select object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
from sys.user_objects
where object_type in ('TABLE','PROCEDURE', 'PACKAGE', 'FUNCTION')
order by nam asc;

-- Session: SYSTEM@
-- Timestamp: 14:43:16.345
Rollback:

-- Timestamp: 14:43:16.348
Disconnect: SYSTEM@

Regards

Mauro

4

A few more questions:

  1. Which Oracle client version are you using?
  2. Does it go away if you uncheck the "Use Oracle Client" box on the login window (you can only do this before you make your first connection)
  3. Does it go away if you add this line to Toad.ini under [SETTINGS]?
    HideServerSideSQLNetBanners=1
  4. I see Connect: SYSTEM@ in your spool sql output. Are you just hiding the DB name or was it not present in the output for some other reason? OK if you are just hiding it. I am more interested if Toad doesn't show it for some reason.
5

1 10.2 ( I still need to connect some old 8.1 and 10.2 client is able to connect up to 19 )
2) Without Oracle client no error
3) with HideServerSideSQLNetBanners=1 no more error
4) I removed the real name of my db for sake of simplicity

Regards

Mauro

6

Hi Mauro.

Ok, perfect. I will have this fixed for next beta. Thank you for the information.

-John

7

Thank you for your great work

Regards

Mauro

1 Like