Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using BULK BIND.....
Sybrand Bakker wrote:
> On 24 Feb 2006 08:39:55 -0800, "Miggins" <mtproc_at_yahoo.co.uk> wrote:
>
>
>>Am i right in thinking this isnt possibe....each field needs to be >>placed in its own collection.
Perhaps I misread the question but this is the source of my statement:
"You cannot retrieve a table of RECORDS by any language other than PLSQL.
You can use a collection of object types, but not records, records (like the other unique plsql type -- boolean) are only in PLSQL."
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:12083187196917
also:
That is because bulk bind cannot use table of composite types. It works fine with a table of native types, but not with a table of objects or records. The compiler does not support that reference to bulk binds fields. For more information see this Metalink note: Binding a Collection With FORALL Fails With ORA-01767or PLS-00103 But this is probably the most common case when someone will want to use the BULK COLLECT and FORALL statements (for example - cursor with parameters and joins of three or more tables). The workaround of this problem is to be used tables of native types
Source:
http://dba-blog.blogspot.com/2005_08_01_dba-blog_archive.html
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Sun Feb 26 2006 - 13:01:34 CST