Home » SQL & PL/SQL » SQL & PL/SQL » ORA-03001: unimplemented feature
ORA-03001: unimplemented feature [message #224473] Wed, 14 March 2007 07:12 Go to next message
mallikj2
Messages: 7
Registered: March 2007
Junior Member
When Am trying

sqlstring := 'SELECT * BULK COLLECT INTO <pl/sql table type> FROM
xxxx '
EXEC_SQL(sqlstring);
Am getting ORA-03001: unimplemented feature Msg, with out the BULK COLLECT INTo the query executes well. how to overcome with this error.
Re: ORA-03001: unimplemented feature [message #224503 is a reply to message #224473] Wed, 14 March 2007 08:02 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
What database version ?
Re: ORA-03001: unimplemented feature [message #224510 is a reply to message #224503] Wed, 14 March 2007 08:32 Go to previous messageGo to next message
mallikj2
Messages: 7
Registered: March 2007
Junior Member
ORACLE 10g
Re: ORA-03001: unimplemented feature [message #224515 is a reply to message #224510] Wed, 14 March 2007 08:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Using a particular client-tool / -version?
Re: ORA-03001: unimplemented feature [message #224581 is a reply to message #224515] Wed, 14 March 2007 13:04 Go to previous messageGo to next message
Ivan
Messages: 180
Registered: June 2000
Senior Member
I haven't tested the code, but use it as a general idea:

declare
   lt dbms_sql.varchar2_table;
begin
   execute immediate 'select name from emp where rownum <= 10'
      bulk collect into lt;
   --
   for i in lt.first .. lt.last
   loop
      dbms_output.put_line ('i=' || i || ', name = ' || lt(i));
   end loop;
end;

Re: ORA-03001: unimplemented feature [message #224659 is a reply to message #224581] Thu, 15 March 2007 00:44 Go to previous message
mallikj2
Messages: 7
Registered: March 2007
Junior Member
Thanks, Ivan i really worked for me
Previous Topic: Tuning this Query
Next Topic: Dumping a table from SAS to ORacle
Goto Forum:
  


Current Time: Sat Dec 10 10:56:41 CST 2016

Total time taken to generate the page: 0.08235 seconds