Home » SQL & PL/SQL » SQL & PL/SQL » Ceate a type with a method inside (Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod , XP)
Ceate a type with a method inside [message #353111] Sat, 11 October 2008 10:23 Go to next message
AMIR64
Messages: 6
Registered: October 2008
Junior Member
Is the syntax below right?

CREATE or replace TYPE RiverType
UNDER WaterType(
length INT,
meets REF WaterType SCOPE
IS Rivers,
runs_through REF StateType
MULTISET SCOPE IS States
)
INSTANCE METHOD leads_to_ocean()
RETURNS OceanType;
Re: Ceate a type with a method inside [message #353115 is a reply to message #353111] Sat, 11 October 2008 11:14 Go to previous message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you get when you try?
Do you think we are SQL syntax analyzer?

If you want us to help you, generally speaking, you must:
* Follow OraFAQ Forum Guide
* Format your post
* Post a full test case we can reproduce
* Use SQL*Plus and copy and paste your session.

Regards
Michel
Previous Topic: query
Next Topic: % from Value
Goto Forum:
  


Current Time: Mon Dec 05 02:44:51 CST 2016

Total time taken to generate the page: 0.14775 seconds