Toad World® Forums

Create TYPE BODY with member functions error


#1

Hi

Use Code Listing 2 and 3 from http://www.oracle.com/technology/oramag/oracle/06-jul/o46sql.html to test

Creating and Object with member functions using
create or replace TYPE BODY gives ORA-00900 (invalid instruction) in the line where MEMBER FUNCTION is defined (Code Listing 3)

(with SQL PLUS the script works)

Also the colapsed code tree is wrong

Regards
Filipe


#2

Hi Fillipe,

Thanks for reporting this issue. We have fixed this in out internal build and you can check it out in next beta.

Thanks,
Vincent


#3

Yes, it’s fixed in 1824, but

CREATE OR REPLACE TYPE “AVGINTERVAL”
AS OBJECT (

runningSum INTERVAL DAY(9) TO SECOND(9),
runningCount NUMBER

)
;
/

do not get the collapsing