Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Inserting records in a cursor solved

Re: Inserting records in a cursor solved

From: <Jared.Still_at_radisys.com>
Date: Wed, 3 Mar 2004 16:18:09 -0800
Message-ID: <OFF8B277F1.DA55583C-ON88256E4D.0001A208-88256E4D.0001943B@radisys.com> 





All this looping is making me nauseated



;)







"Juan Cachito Reyes Pacheco" <jreyes_at_dazasoftware.com>
Sent by: oracle-l-bounce_at_freelists.org


 03/03/2004 01:07 PM


 Please respond to oracle-l

 

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        Re: Inserting records in a cursor solved






thanks chris, jamadagni and igor



Here is the solution, solving (until new bug found) my bug in function
tables :)



FUNCTION TEST


return TYP_CCO_IMPUTACION



as



l_data TYP_CCO_IMPUTACION := TYP_CCO_IMPUTACION();



begin



for i in 1..10



loop



l_data.extend;



l_data(l_data.count) :=



TYO_CCO_IMPUTACION( i,i,i,i,i,i,i );



end loop;




return l_data;



end;









select *



from the ( select cast( test as TYP_CCO_IMPUTACION )



from dual )






Excellent spanglish!



-----Original Message-----


From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
Sent: Wednesday, March 03, 2004 2:56 PM


To: oracle-l_at_freelists.org


Subject: RE: Inserting records in a cursor



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 is
TuBLA ctb.typ_cco_imputacion;


begin


  for i in 1 .. 10


  loop

    TUBLA(i).nTotal := i;
    TUBLA(i).cCCO1  := 'ccol1 ' || i;
    TUBLA(i).cCCO2  := 'ccol2 ' || i;
    TUBLA(i).cCCO3  := 'ccol3 ' || i;
    TUBLA(i).cCCO4  := 'ccol4 ' || i;
    TUBLA(i).cCCO5  := 'ccol5 ' || i;
    TUBLA(i).nMonto := i;




  end loop;


retturn tubla;


end;


/




something like this should work ...


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_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito Reyes
Pacheco


Sent: Wednesday, March 03, 2004 3:43 PM


To: oracle-l_at_freelists.org


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






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_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito Reyes
Pacheco


Sent: Wednesday, March 03, 2004 3:07 PM


To: oracle-l_at_freelists.org


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


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



----------------------------------------------------------------
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 03 2004 - 18:17:01 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US