order sending email, order receiving emails 2004-03-03 - By Juan Cachito Reyes Pacheco
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@(protected) >
To: <oracle-l@(protected) >
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 (See ORA-06531.ora-code.com): Referencia a una recopilación no inicializada
>
> -- -- Original Message -- --
> From: "Jamadagni, Rajendra " <Rajendra.Jamadagni@(protected) >
> To: <oracle-l@(protected) >
> 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@(protected)
> [mailto:oracle-l-bounce@(protected)]On Behalf Of Juan Cachito Reyes
> Pacheco
> Sent: Wednesday, March 03, 2004 3:07 PM
> To: oracle-l@(protected)
> 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@(protected)
> 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@(protected)
> 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
