U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Oracle RefCursor and Stored Procedure

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Oracle RefCursor and Stored Procedure [message #42963]

Thu, 17 April 2014 18:59

aksdb is currently offline

aksdb
Messages: 6
Registered: April 2014

Promising Member

I'm currently evaluating U++, which at a first glance seems pretty awesome. I usually detest C/C++, but U++ showed me that it can indeed look fantastic Smile

Smile

Anyway, our Oracle (11) database at work is handled strictly through stored procedures. For each table there are automatically generated SPs to insert, update and select as well as manually crafted SPs for special tasks. Each function returns a custom struct (containing error code and message), while the actual "results" of the query are in a refcursor as out-parameter.

From what I can see, OCI8Connection provides a .SetParam(int, Sql&) which seems to be intended for exactly such ref-cursors. However I wasn't able to find out how I can make use of it, since the SQL class doesn't give me any way to access that overloaded function.

So: any chance to work in this environment with current U++ SQL? Smile

Smile

Report message to a moderator

Send a private message to this user

[Message index]

		Oracle RefCursor and Stored Procedure By: aksdb on Thu, 17 April 2014 18:59
		Re: Oracle RefCursor and Stored Procedure By: mirek on Tue, 22 April 2014 08:14
		Re: Oracle RefCursor and Stored Procedure By: aksdb on Tue, 22 April 2014 10:03
		Re: Oracle RefCursor and Stored Procedure By: aksdb on Tue, 22 April 2014 11:26
		Re: Oracle RefCursor and Stored Procedure By: mirek on Tue, 22 April 2014 14:28
		Re: Oracle RefCursor and Stored Procedure By: mirek on Tue, 22 April 2014 14:31
		Re: Oracle RefCursor and Stored Procedure By: aksdb on Tue, 22 April 2014 14:53
		Re: Oracle RefCursor and Stored Procedure By: aksdb on Tue, 22 April 2014 16:27
		Re: Oracle RefCursor and Stored Procedure By: mirek on Wed, 23 April 2014 08:27
		Re: Oracle RefCursor and Stored Procedure By: mirek on Wed, 23 April 2014 08:32
		Re: Oracle RefCursor and Stored Procedure By: aksdb on Wed, 23 April 2014 10:22

Previous Topic:	Schema description documentation not matching code behavior
Next Topic:	PATCH: SqlSelect::ForUpdate() should generate nothing for SQLITE3

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Fri Apr 26 23:58:51 CEST 2024

Total time taken to generate the page: 0.06630 seconds