Home » U++ Library support » U++ SQL » Oracle RefCursor and Stored Procedure  
	
		
		
			| Re: Oracle RefCursor and Stored Procedure [message #42994 is a reply to message #42963] | 
			Tue, 22 April 2014 11:26    | 
		 
		
			
				
				
				
					
						  
						aksdb
						 Messages: 6 Registered: April 2014 
						
					 | 
					Promising Member  | 
					 | 
		 
		 
	 | 
 
	
		I was wrong: RawToValue is necessary. However something is wrong there. 
 
I added some debug output to "void  OCI8Connection::SetParam(int i, const Value& q)": 
Cout() << Format("Type is 0x%X (%s)", (int)q.GetType(), q.GetTypeName()) << EOL; 
 
This results in: 
Type is 0x8000000 (N3Upp11RawValueRepIPNS_3SqlEEE)  
 
Obviously, this means that type is != UNKNOWN_V, so we run into the assertion "NEVER();". 
 
Just for the sake of testing it, I moved the relevant check (if(IsTypeRaw<Sql *>(q)) ...) into the default case. This will at least make the Oracle call succeed and I also get a result set I can iterate on, however when the application closes, I get a report about a heap corruption: 
Heap is corrupted --memory-breakpoint__ 1189  
 
Something's very wrong here, I'm afraid.
		
		
		
 |  
	| 
		
	 | 
 
 
 |  
  
 
	
	  | 
	 | 
	
		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  
	 | 
  
Goto Forum:
 
 Current Time: Tue Nov 04 10:26:39 CET 2025 
 Total time taken to generate the page: 0.04150 seconds 
 |