My .NET code is currently using ODP.NET to call a stored procedure many times to operate on various rows in many tables.The .NET code has an array of the rows to change.Only one parameter changes in e
I have the following types: create or replace TYPE mytimestamp AS VARRAY(300) OF TIMESTAMP(6); create or replace TYPE trade_history_dts_array AS VARRAY(300) OFmytimestamp;
I\'m new to Oracle Objects and I have a problem. I don\'t know how to dereference an item from a VARRAY of REFs. Below is some source code that reproduces the problem that I have.
I have a varray defined like: declare TYPE tnr_l IS VARRAY(30) of lve%ROWTYPE; I want this varray to be initialized with a fetch from the database:
Slightly broad question here, but here goes I\'m trying to call an Oracle stored procedure, which returns a VARRAY which is of constructed from a ROWTYPE on one of my tables. For simplicity, lets say
I am trying to write a small program which has to store and retrieve values from database. The database is object relational.
I\'ve got a PL/SQL VArray that I\'m filling with a BULK COLLECT query like this: SE开发者_运维技巧LECT id
加载中,请稍侯......