Re: PL/SQL questions

Gennady <gennadyb_at_halcosoftware.com> schreef in berichtnieuws 3907797a$0$15821_at_fountain.mindlink.net...
> Hello:
> I am using Oracle 8.0.5 on NT4 (SP5).
> I have two questions:
> 1.I have a composite variable:
> v_tablerow my_table%ROWTYPE;
> Is there a way to access an element of v_tablerow by field index, not by
> field name?
> I need the solution to insert a tuple to table T2 from cursor on table T1
> without using field names.
> 2.Is there a way to find particular record (like FindFirst DAO method)
 using
> PL/SQL cursor
> created on "select * from my_table" active set?
>
> Thanks,
> Gennady
>
>

1 this isn't possible
2 the same applies here

Sorry,

Sybrand Bakker, Oracle DBA Received on Thu Apr 27 2000 - 00:00:00 CDT