Re: Pro C/Java returning PLSQL Tables

From: jeperkins4 <johnp_at_1rent.com>
Date: Tue, 16 Nov 1999 20:04:19 GMT
Message-ID: <80sdbu$ga1$1@nnrp1.deja.com>

What if I want to insert or update values in the database using this method, which would return a PL/SQL Table. This way I always get a result set that is identical in it's signature with the get. When I tried to do this, I got the following error:

ORA-14551: cannot perform a DML operation inside a query

Thanks,

John

> tkyte_at_8.0>
> tkyte_at_8.0> REM here we go... selecting from it:
> tkyte_at_8.0>
> tkyte_at_8.0> select *
> 2 from THE ( select cast( getMyTableType() as mytableType ) from
dual ) a
> 3 /
>
> X Y Z
> ---------- --------- -------------------------
> 1 06-NOV-99 This is row 1
> 2 07-NOV-99 This is row 2
> 3 08-NOV-99 This is row 3
> 4 09-NOV-99 This is row 4
> 5 10-NOV-99 This is row 5
>
> Since every language can deal with a Query -- this lets you
get 'tables of
> records' back quite easily as result sets (works in JDBC as well).
>

--
John Perkins
Database Applications Engineer
Rentals.com
459 Hamilton Ave, Suite 202
Palo Alto, CA 94301

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 14:04:19 CST