I got TNS Oracle error while accessing nested table

[Dmytro]

ora-12518 while select from table with nested table type as table column
like this

SQL> CREATE TYPE first_names_t IS VARRAY (2) OF VARCHAR2 (100);
2 /
Type created.
SQL> CREATE TYPE child_names_t IS VARRAY (1) OF VARCHAR2 (100);
2 /
Type created.
REM Раздел B
SQL> CREATE TABLE family (
2 surname VARCHAR2(1000)
3 , parent_names first_names_t
4 , children_names child_names_t
5 );
Table created.

It works in SHARED server mode but not in DEDICATED

It works properly in SQL PLus in BOTH modes

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 15).

 

[Dmytro]

Send to support email

 

[Dmytro]

It seems that was problem with low value of "processes" oracle init parameter and tns listener failed to open new connection. Sorry for bothering. Now it works properly.