RE: SOLVED: How to define a Type with multiple columns ,for bulk fetch

From: Kevin Lange <klange_at_ppoone.com>
Date: Wed, 10 Mar 2004 16:19:36 -0600
Message-ID: <ED1256BD4F253C44B1627B2D365A334F035658@ppoone1.ppoone.com>

How about creating it as an Object.

  create type address_type as object
  (street varchar2(50),
   city varchar2(25),
   state char(2),
   zip number);

-----Original Message-----
From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com] Sent: Wednesday, March 10, 2004 4:07 PM
To: oracle-l_at_freelists.org
Subject: SOLVED: How to define a Type with multiple columns ,for bulk fetch

tCTS_CUENTA DBMS_SQL.VARCHAR2_TABLE;

tCTS_MONEDA DBMS_SQL.VARCHAR2_TABLE;

CURSOR uLiq IS

SELECT CTS_CUENTA, CTS_MONEDA FROM CTALIQFON, CUENTAS WHERE CTS_CUENTA = LQF_CUENTA; BEGIN fetch uLiq bulk collect into tCTS_CUENTA,tCTS_MONEDA;

Original Message ----- From: "Juan Cachito Reyes Pacheco" <jreyes_at_dazasoftware.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, March 10, 2004 5:42 PM Subject: How to define a Type with multiple columns ,for bulk fetch

> Hi sorry another question more, how can I define a type with TWO OR MORE
> columns
> to bulk fetch in this way
>
> DECLARE
> TYPE TEST IS TABLE OF VARCHAR2(20);
> TEST1 test;
> i number := 0;
> cursor c is SELECT LQF_CUENTA FROM CTALIQFON;
> BEGIN
> open c;
> loop
> fetch c bulk collect into test1;
> for i in 1..test1.count loop
> dbms_output.put_line(test1(i));
> end loop;
> exit when c%notfound;
> end loop;
>
>
>
> For one column I can do this
> TYPE TEST IS TABLE OF VARCHAR2(20);
>
> If I use a table I can do this
> TABLA TYPE TEST IS TABLE LATABLA%ROWTYPE;
>
> Now if I do something like
> TYPE tLiq IS RECORD (
> CTS_CUENTA VARCHAR2(20),
> CTS_MONEDA VARCHAR2(3));
>
> fetch c bulk collect into tLiq, gives error.
> pls-00403
>
>
> Thanks
>

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 10 2004 - 16:18:37 CST