Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: order sending email, order receiving emails

Re: order sending email, order receiving emails

From: <Jared.Still_at_radisys.com>
Date: Wed, 3 Mar 2004 16:05:53 -0800
Message-ID: <OF23CBA3B3.82FA0230-ON88256E4D.0000845B-88256E4D.000074BE@radisys.com>


The internet is asynchronous.

"Juan Cachito Reyes Pacheco" <jreyes_at_dazasoftware.com> Sent by: oracle-l-bounce_at_freelists.org
 03/03/2004 02:01 PM
 Please respond to oracle-l  

        To:     <oracle-l_at_freelists.org>
        cc: 
        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???

> 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_cco_imputacion;
>
> begin
>
> Tabla(1).ntotal := 1;
>
> Tabla(2).ntotal := 1;
>
> Tabla(3).ntotal := 1;
>
> tabla(4).ntotal := 1;
>
> --RETURN Tabla;
>
> rollback;
>
> end;
>
> 16:39:00 ORA-06531: Referencia a una recopilación no inicializada
>
> ----- Original Message -----
> From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> To: <oracle-l_at_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 := 1;
> tubla[2].ntotal := 1;
> tubla[3].ntotal := 1;
> tubla[4].ntotal := 1;
>
> Raj
>


--

> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> select standard_disclaimer from company_requirements;
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito Reyes
> Pacheco
> Sent: Wednesday, March 03, 2004 3:07 PM
> To: oracle-l_at_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_cco_imputacion 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_cco_imputacion AS TABLE OF CTB.TYO_CCO_IMPUTACION;
>
> /
>
>
>
> create functoin load return ctb.typ_cco_imputacion
>
> TuBLA typ_cco_imputacion;
>
> 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_at_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_at_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_at_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_at_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_at_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 -----------------------------------------------------------------
Received on Wed Mar 03 2004 - 18:04:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US