Re: SOLVED: How to define a Type with multiple columns ,for bulk fetch
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 18:40:23 -0400
Thank you
Yes, but create an object for every specific select, that gathers specific
columns, you
will have lot and lot of objects.
----- Original Message -----
From: "Kevin Lange" <klange@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, March 10, 2004 6:19 PM
Subject: RE: SOLVED: How to define a Type with multiple columns ,for bulk
fetch
> 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@xxxxxxxxxxxxxxxx]
> Sent: Wednesday, March 10, 2004 4:07 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@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:
