ODBC call to a stored procedure not working...

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1996/11/21
Message-ID: <5723dg$506_at_nntp1.u.washington.edu>#1/1

I have a stored procedure simply does a select query to a table. It works using sqlplus but does not when called through ODBC connection.

The procedure looks like this:

  CREATE OR REPLACE PROCEDURE GetEmpTable   AS

    CURSOR c1 IS

       SELECT empno, name, sal, hiredate 
         FROM Emp;

  BEGIN
    DBMS_OUTPUT.ENABLE;
    FOR rec in c1 LOOP

        DBMS_OUTPUT.PUT_LINE (
               rec.empno||'   '||
               rec.name||'   '||
               rec.sal||'   '||
               rec.hiredate);

    END LOOP;
  END; Is there any trick when calling procedure through ODBC? Thanks in advance!!!

Leslie Received on Thu Nov 21 1996 - 00:00:00 CET