Re: Cold Fusion and Oracle

[Adrocknaphobia]

Janet's scripts here are dead on for how it should be done. I've missed the earliest part of this thread, so I'm not sure if this is what you originally had, but this is what it should be.

What happens when you run this script and call it from CF?

-Adam

> -----Original Message-----
> From: Janet Schmitt [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 9, 2004 01:52 AM
> To: 'CF-Talk'
> Subject: Re: Cold Fusion and Oracle
>
> I would try something like this for the Oracle portion:
>
> CREATE OR REPLACE
> PACKAGE schemaname.studentpackage
> IS
>     TYPE student_type_ref_cursor IS REF CURSOR;
>
>     PROCEDURE test_dlc_sp_getStudentInfo(studentID IN number,
> student_cursor IN OUT student_type_ref_cursor);
> END;
>
> Create or replace package body schemaname.studentpackage
> IS
>
> PROCEDURE test_dlc_sp_getStudentInfo (
>       studentID IN number, student_cursor IN OUT student_type_ref_cursor)
> is
> begin
>          open student_cursor
>                  for
>                          select sFirst, sLast, sOrient
>                          from tblStudentInfo
>                          where sid = studentID;
> end;
>
> END studentpackage;
>
>
>
>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---