Home » RDBMS Server » Server Administration » cursor and function
cursor and function [message #374228] Thu, 31 May 2001 07:44 Go to next message
Ben
Messages: 48
Registered: January 2000
Member
Hi All,

I have a stored function I need to use. However, my app cannot call function directly so I need to write a stored procedure to wrap the function since my app can only call stored proc. To make it complicated, my app can only accept cursor as return from the stored proc. The stored func will return a number and it will update a set of tables when it is called. I like to ask how to return a cursor for a function in a stored proc.

Thanks!

Report message to a moderator

Re: cursor and function [message #374236 is a reply to message #374228] Thu, 31 May 2001 22:39 Go to previous message
Rakesh Goel
Messages: 8
Registered: May 2001
Junior Member
you can use
select yourfunction(value1,value2,...) from dual;
instead of calling SP. or you can call above query within SP also.

Report message to a moderator

Previous Topic: Query Help !!!!
Next Topic: help ..help..help me!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 03:16:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.