I've never had problems vith TStoredProcedures... Check the Param Type...
<xiaozhang_at_my-deja.com> wrote in message news:92ecqq$fp3$1_at_nnrp1.deja.com...
> Hi:
> I am new to delphi.
> Could someonw help me and let me know how to call select Oracle stored
> procedure from delphi program. such as the following Oracle proc.
>
> CREATE OR REPLACE PROCEDURE TESTER1.PRO_TEST1
> (v_isactive IN atsschedule.isactive%TYPE )
> AS
> i number;
> v_name atsschedule.taskname%TYPE;
> cursor c1 is
> select taskid, taskname from atsschedule
> where isactive = v_isactive;
> BEGIN
> For tk In c1 LOOP
> i := tk.taskid;
> v_name := tk.taskname;
> END LOOP;
>
> END;
>
> I have tried to use different procedures and different components such
> as TStoredProc, TQuery and etc, but not working.
>
> Thanbks!
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 02 2001 - 10:44:42 CST
