Help! Oracle8i--table as output parameter??

From: Dana Jian <dana_jian_at_hotmail.com>
Date: Tue, 4 Apr 2000 11:07:08 -0400
Message-ID: <38ea051c$0$1380@news.choice.net>

Hello,

In Oracle8, we can create a procedure which pass array as output parameters to Visual Basic.

for example,
TYPE ty_id IS TABLE OF EMPLOYEE.EMP_ID%TYPE   INDEX BY BINARY_INTEGER;
TYPE ty_name IS TABLE OF EMPLOYEE.EMP_NAME%TYPE   INDEX BY BINARY_INTEGER; PROCEDURE SP_GET_ALL_CLASS_OBJECT_COUNT (

 in_class_id     IN  NUMBER,
 emp_name     OUT    ty_name,
 emp_id     OUT    ty_id

)
IS

v_count NUMBER DEFAULT 1;

CURSOR cr_result IS
SELECT emp_id, emp_name
FROM Employee
WHERE .... BEGIN

  For v_one IN cr_result LOOP
    emp_id(v_count)  := v_one.emp_id;
    emp_name(v_count)  := v_one.emp_name;

      v_count := v_count + 1;

  END LOOP; Now, my question is, how to do the same in Oracle8i?? When I was trying to do the same with Oracle 8i, there's error message-- Oracle8i use REF Cursor to pass back the result set.

In Oracle8i(we're using OLEDB driver), is there any way to pass array back to VB???

Thanks a LOT for your help, we greatly appreciate it!

Dana
dana_jian_at_hotmail.com Received on Tue Apr 04 2000 - 10:07:08 CDT