SQL & PL/SQL

Hi Sir/Mm,

1)

I have this particular value assignment code snippet in a stored procedure :

dbms_sql_dateArr  ( x ) := dateArr (lDateIndex);

2)

Both these are of the same declaration type and type.

Please find below the declarations of the above variables and their "TYPE" :

2.1)

Declarations inside the Stored procedure :

dbms_sql_dateArr   DBMS_SQL.date_table

dateArr            date_table;

(Note: Addition DBMS_SQL turned out to be mandatory)

2.2)

Script of the original declaration type :

create or replace

TYPE                  "DATE_TABLE" IS TABLE OF TIMESTAMP(6) WITH TIME ZONE

Now my issue is that "dateArr (lDateIndex);" in point 1) has a timestamp value along with milliseconds.

But "dbms_sql_dateArr  ( x ) :" gets stripped of the milliseconds value.

Could you please help me as i could not find answers in the forum?

Regards,

Karthik.