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 -----------------------------------------------------------------