Home » SQL & PL/SQL » SQL & PL/SQL » nested tables help
nested tables help [message #8069] Thu, 24 July 2003 11:27
Mihai Cristofor
Messages: 8
Registered: July 2003
Junior Member
I want to insert new records in a nested table which allready has some records.
I used something like:
insert into the (select nested_table_name from parent_table_name where <condition>)
values (...);
In the command line it works fine, but when i use it in a stored procedure i receive a strange error messaje saying something like: internal error code, ... [[]],[[]],[[]],[[]]...
So, how can i insert new records in a nested table using a stored procedure ??? Thank You.
Previous Topic: Freelist
Next Topic: Execute immediate
Goto Forum:
  


Current Time: Fri Apr 26 23:35:54 CDT 2024