U++ forum: Welcome to the forum

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

Re: Oracle RefCursor and Stored Procedure [message #42990 is a reply to message #42963]

Tue, 22 April 2014 08:14

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

I cannot say I have used it ever, but from what I see in the code, the trick is to use "raw" Execute and pass a pointer to Sql using RawValue.

Something like (sorry for the lack of knowledge of Oracle syntax):

Sql out;
SQL.Execute("call x(?)", RawToValue(&out));

Mirek

[Updated on: Tue, 22 April 2014 08:14]

Report message to a moderator

[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) ] [

] [

]

Current Time: Tue May 07 22:01:01 CEST 2024

Total time taken to generate the page: 0.02274 seconds