VA & PL/SQL cursor variables 
Author Message
 VA & PL/SQL cursor variables

Hello there !

My environment:
        VA 3.0a ST single OS/2.
        Oracle native database support.
        Oracle database servers 7.2 , 7.3

My question:
Does anyone know how to get a cursor variable's data from
an Oracle's PL/SQL procedure into VA Smalltalk client ?

Cursor variables, supported from ver. 2.2 of PL/SQL, are usually
used as pointers to multiple row query data.

In VA3.0a there is no such type as "cursor variable" or "refcursor"
in a drop-down list in  Stored Procedure Specifications Settings.

It seems a little bit clumsy to play with fixed size array
variables since cursor variables became available in PL/SQL.

Thanks for help



 Krzysztof DOROTA ...................... Helsinki University of Technology
 Administration, Information Systems .. Otakaari 1, SF-02150 Espoo Finland

Fri, 12 Feb 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Using SQL Server with VA PL/I

2. Binding Oracle PL/SQL variable in VW2.5

3. tcl, aol, oracle & return PL/SQL Table

4. Migrating from OS/VS PL/I to VA PL/I

5. VA[NT4]: Cannot load font cursor in runtime

6. CW SQL Cursor Support?

7. Invalid Cursor State Error - SQL in C5EE

8. Calling a MS-SQL Stored Procedures OUTSIDE of a Cursor

9. SQL cursor error, repost

10. Very urgent ! SQL Cursor error, Help

11. VA PL/I using a C++ DLL

12. OS/390 2.10 VA PL/I IVP COND CODE 0218


Powered by phpBB® Forum Software