From oracle-l-bounce@freelists.org Wed Mar 3 18:04:29 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2404T920702 for ; Wed, 3 Mar 2004 18:04:29 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2404Ao20663 for ; Wed, 3 Mar 2004 18:04:10 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28BE3395234; Wed, 3 Mar 2004 19:03:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 19:02:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA92F394A72 for ; Wed, 3 Mar 2004 19:02:16 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id 65B25142E0F; Wed, 3 Mar 2004 16:06:06 -0800 (PST) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAAA6RJn_; Wed Mar 3 16:05:53 2004 To: oracle-l@freelists.org Subject: Re: order sending email, order receiving emails MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: Jared.Still@radisys.com Date: Wed, 3 Mar 2004 16:05:53 -0800 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 5.0.12 |February 13, 2003) at 03/03/2004 04:02:52 PM, Serialize complete at 03/03/2004 04:02:52 PM Content-Type: multipart/alternative; boundary="=_alternative 000074BC88256E4D_=" X-archive-position: 273 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --=_alternative 000074BC88256E4D_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The internet is asynchronous. "Juan Cachito Reyes Pacheco" Sent by: oracle-l-bounce@freelists.org 03/03/2004 02:01 PM Please respond to oracle-l =20 To: cc:=20 Subject: order sending email, order receiving emails I sent this email before sending the solved one. But I received first the solved email first and after this email. The emails are not sent in sequence to the list??? ----- Original Message -----=20 From: "Juan Cachito Reyes Pacheco" To: Sent: Wednesday, March 03, 2004 4:43 PM Subject: Re: Inserting records in a cursor > Could you please give a complete example creating a cursor, and adding > values and returning :) pleeease... if I'm not abusing of you. > I'm getting other error messages. > > > declare > > Tabla ctb.typ=5Fcco=5Fimputacion; > > begin > > Tabla(1).ntotal :=3D 1; > > Tabla(2).ntotal :=3D 1; > > Tabla(3).ntotal :=3D 1; > > tabla(4).ntotal :=3D 1; > > --RETURN Tabla; > > rollback; > > end; > > 16:39:00 ORA-06531: Referencia a una recopilaci=F3n no inicializada > > ----- Original Message -----=20 > From: "Jamadagni, Rajendra" > To: > Sent: Wednesday, March 03, 2004 4:16 PM > Subject: RE: Inserting records in a cursor > > > you are probably confused between a table (a rdbms entity) and a collection > (aka pl/sql table). Collections do not use DML statements, you need to treat > them like arrays ... that's what they are. > > tubla[1].ntotal :=3D 1; > tubla[2].ntotal :=3D 1; > tubla[3].ntotal :=3D 1; > tubla[4].ntotal :=3D 1; > > Raj >=20 -------------------------------------------------------------------------- -- > ---- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > select standard=5Fdisclaimer from company=5Frequirements; > QOTD: Any clod can have facts, having an opinion is an art ! > > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Juan Cachito Reyes > Pacheco > Sent: Wednesday, March 03, 2004 3:07 PM > To: oracle-l@freelists.org > Subject: Inserting records in a cursor > > > Hi, maybe this is a stupid question, but I didn't it before, I want to > create a cursor load data, and return in in a funciton > something like > > If you can please, thank you. > CREATE OR REPLACE > > TYPE ctb.tyo=5Fcco=5Fimputacion AS OBJECT > > ( > > nTotal NUMBER, > > cCCO1 VARCHAR2(9), > > cCCO2 VARCHAR2(9), > > cCCO3 VARCHAR2(9), > > cCCO4 VARCHAR2(9), > > cCCO5 VARCHAR2(9), > > nMonto NUMBER(16,2) > > ) > > / > > CREATE OR REPLACE > > TYPE ctb.typ=5Fcco=5Fimputacion AS TABLE OF CTB.TYO=5FCCO=5FIMPUTACION; > > / > > > > create functoin load return ctb.typ=5Fcco=5Fimputacion > > TuBLA typ=5Fcco=5Fimputacion; > > begin > > insert into TUBLA values(1,2,3,4); > > insert into TUBLA values(1,4,3,4); > > .... > > retturn tubla > > end; > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --=_alternative 000074BC88256E4D_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
The internet is asynchronous.



"Juan Cachito Reyes Pacheco&= quot; <jreyes@dazasoftware.com>
Sent by: oracle-l-bounce@freelists.o= rg

 03/03/2004 02:01 PM
 Please respond to oracle-l

       
        To: &nbs= p;      <oracle-l@freelists.org>
        cc: &nbs= p;      
        Subject:=        order sending email, order receiving emails



I sent this email before sending th= e solved one.

But I received first the solved email first and after this email.
The emails are not sent in sequence to the list???

----- Original Message -----
From: "Juan Cachito Reyes Pacheco" <jreyes@dazasoftware.com>= ;
To: <oracle-l@freelists.org>
Sent: Wednesday, March 03, 2004 4:43 PM
Subject: Re: Inserting records in a cursor


> Could you please give a complete example creating a cursor, and adding=
> values and returning :) pleeease... if I'm not abusing of you.
> I'm getting other error messages.
>
>
> declare
>
>  Tabla ctb.typ=5Fcco=5Fimputacion;
>
> begin
>
> Tabla(1).ntotal :=3D 1;
>
> Tabla(2).ntotal :=3D 1;
>
> Tabla(3).ntotal :=3D 1;
>
> tabla(4).ntotal :=3D 1;
>
> --RETURN Tabla;
>
> rollback;
>
> end;
>
> 16:39:00  ORA-06531: Referencia a una recopilaci=F3n no inicializ= ada
>
> ----- Original Message -----
> From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@espn.com&= gt;
> To: <oracle-l@freelists.org>
> Sent: Wednesday, March 03, 2004 4:16 PM
> Subject: RE: Inserting records in a cursor
>
>
> you are probably confused between a table (a rdbms entity) and a
collection
> (aka pl/sql table). Collections do not use DML statements, you need to=
treat
> them like arrays ... that's what they are.
>
> tubla[1].ntotal :=3D 1;
> tubla[2].ntotal :=3D 1;
> tubla[3].ntotal :=3D 1;
> tubla[4].ntotal :=3D 1;
>
> Raj
> ----------------------------------------------------------------------= ----
--
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> select standard=5Fdisclaimer from company=5Frequirements;
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -----Original Message-----
> From: oracle-l-bounce@freelists.org
> [mailto:oracle-l-bounce@freelists.org]On Behalf Of Juan Cachito Reyes<= br> > Pacheco
> Sent: Wednesday, March 03, 2004 3:07 PM
> To: oracle-l@freelists.org
> Subject: Inserting records in a cursor
>
>
> Hi, maybe this is a stupid question, but I didn't it before, I want to=
> create a cursor load data, and return in in a funciton
> something like
>
> If you can please, thank you.
> CREATE OR REPLACE
>
> TYPE ctb.tyo=5Fcco=5Fimputacion AS OBJECT
>
> (
>
> nTotal NUMBER,
>
> cCCO1 VARCHAR2(9),
>
> cCCO2 VARCHAR2(9),
>
> cCCO3 VARCHAR2(9),
>
> cCCO4 VARCHAR2(9),
>
> cCCO5 VARCHAR2(9),
>
> nMonto NUMBER(16,2)
>
> )
>
> /
>

> CREATE OR REPLACE
>
> TYPE ctb.typ=5Fcco=5Fimputacion AS TABLE OF CTB.TYO=5FCCO=5FIMPUTACION= ;
>
> /
>
>
>
> create functoin load return ctb.typ=5Fcco=5Fimputacion
>
> TuBLA typ=5Fcco=5Fimputacion;
>
> begin
>
> insert into TUBLA values(1,2,3,4);
>
> insert into TUBLA values(1,4,3,4);
>
> ....
>
> retturn tubla
>
> end;
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


--=_alternative 000074BC88256E4D_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------