Oracle procedures, RefCursor and ResultColumns

Any template questions or comments or suggestions

Oracle procedures, RefCursor and ResultColumns

Postby grgouala on Tue Dec 19, 2006 8:47 am

Hi,

we are using myGeneration on Oracle 9. Our need is to generate a class based on a stored procedure.
But we experienced that the ResultColumns property of the IProcedure object does not return anything on ORACLE. On the contrary, it works well with the equivalent stored procedure on SQL server.

Is there a workaround ?

greg
grgouala
Lurker
 
Posts: 1
Joined: Tue Dec 19, 2006 8:41 am

Postby mike.griffin on Tue Dec 19, 2006 2:19 pm

I will have to see if this works at home, you can always use IDatabase.ExecuteSQL to execute some raw sql against oracle to get that info? I thought we suppoed that on Oracle but I just can't remember, I'll check tonight
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN


Return to General Template Questions/Comments

Who is online

Users browsing this forum: No registered users and 1 guest

cron