current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Join the Stack Overflow Community
Stack Overflow is a community of 6.4 million programmers, just like you, helping each other.
Join them; it only takes a minute:
Sign up
up vote 1 down vote favorite

I have a problem with running Unit Test using Sql Developer for procedure containing e.g. dbms_sql.timestamp_table like:

create or replace procedure foo (p_arg_1 in dbms_sql.timestamp_table) is
begin
  null;
end;
/

I try to run test but I receive error (polish):

java.sql.SQLException: Niepoprawny typ elementu tabeli indeksu PL/SQL

By googling I translated it to:

ORA-1709: "Invalid PL/SQL Index Table element type."

Same problem for date_table but there is no errors for following:

dbms_sql.varchar2_table
dbms_sql.number_table

Is this a bug? Or am I doing something wrong? Theoretically Sql Developer interface is allowing to test such structures...

share|improve this question
    
If your Oracle database is below Oracle 8i then dbms_sql is not avaialble. Check your oracle version. – XING Dec 9 at 13:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.