RE: PL/SQL Question

From: Davey, Alan <Alan.Davey_at_encodasystems.com>
Date: Wed, 18 Aug 2004 07:35:40 -0500
Message-ID: <746DCE6FEC476842B2229E15EBFC1B9E0B431B@mempexc0013.encodasystem s.net>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]=  On Behalf Of Raj Jamadagni
Sent: Wednesday, August 18, 2004 8:01 AM To: oracle-l_at_freelists.org
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_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
-----------------------------------------------------------------

"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_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 Aug 18 2004 - 07:39:22 CDT