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 #42993 is a reply to message #42963]

Tue, 22 April 2014 10:03

aksdb
Messages: 6
Registered: April 2014

Promising Member

Close, it actually works without the RawToValue Smile

I wasn't aware that a typed pointer would be wrapped into Value and correctly identified later on.
So at least I got the call now. I just need to figure out, why Oracle doesn't like the refcursor/result set and throws me an

PLS-00382: expression is of wrong type

It's probably because we use "custom" ref cursors

 TYPE ref_cursor_type IS
      REF CURSOR RETURN ref_cursor_rec;

(where ref_cursor_rec is a custom structure containing the fields to be returned).

I didn't expect it to be that much of a hassle. But I'll hopefully figure this out. Thanks for that pointer (literally)! Smile

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 13:16:42 CEST 2024

Total time taken to generate the page: 0.02504 seconds