RE: PL/SQL Question
- From: "Davey, Alan" <Alan.Davey@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Aug 2004 07:35:40 -0500
Hi Raj,
I tried that but without any luck.
I also tried using column%type when declaring the "type ... table of ...=
collection object".
From what I can see, the returning into only works if you use the values=
clause or if your insert as select only returns one record. In the latter=
case I could simply store into a variable and not a collection, or use=
seq_xxx.currval for subsequent operations.
Thanks for the suggestion though.
Alan
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]=
On Behalf Of Raj Jamadagni
Sent: Wednesday, August 18, 2004 8:01 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: PL/SQL Question
Alan,
try with x column type as number instead of integer ... there is something=
about bulk collect and
implicit data type conversion in 817 ... can't think of it precisely.
Raj
=3D=3D=3D=3D=3D
Best Regards
Raj
---------------------------------------------------------
select mandatory_disclaimer from company_requirements;
=0D
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo=0D
----------------------------------------------------------------
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
-----------------------------------------------------------------
"This information in this e-mail is intended solely=0D
for the addressee and may contain information=0D
which is confidential or privileged. Access to this
e-mail by anyone else is unauthorized. If you=0D
are not the intended recipient, or believe that=0D
you have received this communication in error,=0D
please do not print, copy, retransmit,=0D
disseminate, or otherwise use the information.=0D
Also, please notify the sender that you have=0D
received this e-mail in error, and delete the=0D
copy you received."
----------------------------------------------------------------
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:
