order sending email, order receiving emails
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 18:01:19 -0400
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 -----
From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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_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@xxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Juan Cachito Reyes
> Pacheco
> Sent: Wednesday, March 03, 2004 3:07 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
