Meaningless Drivel is fun!*
The moose likes Oracle/OAS and the fly likes how to use userdefined datatype in Oracle 8i Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "how to use userdefined datatype in Oracle 8i" Watch "how to use userdefined datatype in Oracle 8i" New topic
Author

how to use userdefined datatype in Oracle 8i

Sona Patel
Ranch Hand

Joined: Mar 30, 2009
Posts: 75
Hello All...

I have created user defined datatype in oracle 8i as seen below.


I want to use this variable in oracle 8i as seen below.



how to use this user defined datatype in function in oracle 8i?

Thanks
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
it ran ok on 11i after putting a ';' after your end statement. Not sure why it would not run if 8i supports object types.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: how to use userdefined datatype in Oracle 8i