# 22. Virtuoso Functions Guide - rnext

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
att_local_name
quote_dotted
rclose
rexecute
rmoreresults
rnext
rstmtexec
sql_columns
sql_config_data_sour...
sql_data_sources
sql_driver_connect
sql_get_installed_dr...
sql_get_private_prof...
sql_gettypeinfo
sql_primary_keys
sql_procedures
sql_remove_dsn_from_...
sql_special_columns
sql_statistics
sql_tables
sql_transact
sql_write_file_dsn
sql_write_private_pr...
vd_remote_data_sourc...
vd_remote_proc_wrapp...
vd_remote_table
vd_statistics
vdd_disconnect_data_...
vdd_measure_rpc_time
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## rnext

Get next result from a remote result set
integer retcode rnext (in cursor_handle long, out row_array vector, out sql_state varchar, out sql_error varchar);
Parameters
cursor_handle – The long cursor handle as obtained from rexecute.
row_array – An output vector that will contain the result columns.
sql_state – Optional varchar output parameter for SQL state.
sql_error – Optional varchar output parameter for any error message.
Return Values

All data is returned in output parameters.

Description

Use rnext in combination with rmoreresults to iterate over a result set produced by a statement run in a remote data source with rexecute.

- open a cursor with rexecute.
- loop over the results with rnext
- if rmoreresults does not return an error or SQL_NO_DATA_FOUND continue the loop with rnext, otherwise
- close the cursor with rclose

See Also

rexecute, rmoreresults, rclose.