Return value for stored function 
Author Message
 Return value for stored function

Hi everyone

I have a VC++ aplication, and I use ODBC connection with Oracle database
and CDatabase/CRecordset classes. This is pretty straight so far. The
problem is when I want to return values from stored functions. I can
send an SQL with m_pdb.ExecuteSQL() but no return value...
Let's say that I have function counting the number of fields in the
table.
Like:

RETURN int
IS
  a NUMBER;
BEGIN
   SELECT COUNT(*) INTO a FROM customer;
   RETURN a;
END;

What is the right way to get the number somewhere in the application?
I have tried to implement logic from
Recordset: Declaring a Class for a Predefined Query (ODBC) article in
MSDN but guess I'm making some mistake. That is why I need some
direction, example or code.
Thanks in advance

Sent via Deja.com http://www.***.com/
Before you buy.



Fri, 02 Aug 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Help.. How to return values from Stored Functions in oracle

2. Stored Function Return Value ADO

3. Stored Function Return Value ADO

4. Return values (stored functions) and named parameters

5. Can a stored function returns a value to ASP ADO

6. Can a stored function returns value to ASP ADO

7. RETURN VALUE in stored procedure not always returning to ADO

8. Stored procedure returning empty output parameters or return value

9. How to capture the return value and output parameter value of a stored procedure in VB

10. Stored procedure returning variable value, not column value?

11. Return value and Output values from Stored Procedure

12. return select values in stored procedure to a calling stored procedure


 
Powered by phpBB® Forum Software