AW: Object Types in PL/SQL

2003-07-16 Thread Stefan Jahnke
Thanks all. Looks like I'll have to go with the add-an-extra-parameter method for now as a workaround. I don't know yet wether we're going to raise a TAR right away. The manual is a little bit unclear about overriding the default constructor. So I might contact a friend at Oracle first. I'll post

AW: Object Types in PL/SQL

2003-07-15 Thread Stefan Jahnke
Hi The anonnymous block at the bottom of my email is just a little test driver. Basically, I don't use subtyping here. I just override the default constructor. If I don't implement a constructor at all, I would look like this: CREATE OR REPLACE TYPE tVNR AS OBJECT ( vVNR VARCHAR2(14),

Re: AW: Object Types in PL/SQL

2003-07-15 Thread rgaffuri
ok then i missed it. where is the overriding taking place? I saw a base constructor.. where was the 'override'? From: Stefan Jahnke [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 08:30:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: AW: Object Types in PL/SQL Hi

AW: AW: Object Types in PL/SQL

2003-07-15 Thread Stefan Jahnke
: Re: AW: Object Types in PL/SQL ok then i missed it. where is the overriding taking place? I saw a base constructor.. where was the 'override'? From: Stefan Jahnke [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 08:30:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: AW

Re: AW: Object Types in PL/SQL

2003-07-15 Thread Nuno Souto
!). BTW this works also in 8i, it's not just 9i. Cheers Nuno Souto [EMAIL PROTECTED] Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 15. Juli 2003 14:44 An: Multiple recipients of list ORACLE-L Betreff: Re: AW: Object Types in PL/SQL ok then i missed it. where

Re: Re: AW: Object Types in PL/SQL

2003-07-15 Thread rgaffuri
support guys say. If you do, please post what they say. From: Nuno Souto [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 09:49:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: AW: Object Types in PL/SQL - Original Message - That is what I want to do