Ref Cursor.

forum.centura.team.developer (1998-2005) & forum.sqlwindows (2000-2005)
kana...

Ref Cursor.

Post by kana... » 20 Sep 2005, 12:38

 Posted by:  kana...@gmail.com 

Hi ,
I have created a store procedure using a ref cursor.

Parameter : nId number,crref refcursor

how i can execute this procedure in Centura front end. what will be the
result set in Centura.?
Thanks.

kana...

Re: Ref Cursor.

Post by kana... » 20 Sep 2005, 12:56

 Posted by:  kana...@gmail.com 

Hi ,
I have created a store procedure using a ref cursor.

Parameter : nId number,crref refcursor

how i can execute this procedure in Centura front end. what will be the
result set in Centura.?
Thanks.

j...@ubp.ch

Re: Ref Cursor.

Post by j...@ubp.ch » 21 Sep 2005, 09:54

 Posted by:  j...@ubp.ch <j...@ubp.ch> 

You could find the information on www.Centurasoft.com in the white
paper or diretcly to theses addresses :
http://www.Centurasoft.com/Downloads/OraStorProcRS.pdf
http://www.Centurasoft.com/Downloads/SQLRoutertoOLEDB.pdf?bcsi_scan_F7366251CE3356BF=0&bcsi_scan_filename=SQLRoutertoOLEDB.pdf

But you have to use OLEDB (I'm using Centura 3.1, with Oracle an OLE
DB)

JL

kana...

Re: Ref Cursor.

Post by kana... » 21 Sep 2005, 13:48

 Posted by:  kana...@gmail.com 

Hi ,
Thanks!. Does ref cursor work on Centura 2.1?

Thank you!.

Return to “forum.sqlwindows”

Who is online

Users browsing this forum: [Ccbot] and 0 guests