Did some further research into this issue and I don't even think it is
possible to return a recordset from an oracle stored procedure.
For anyone interested here is the basics of the stored procedure
execution/creation between oracle & cf
http://www.allaire.com/Handlers/index.cfm?ID=1469&Method=Full
and here is what I believe needs to happen to actually return a recordset:
http://www.allaire.com/Handlers/index.cfm?ID=8353&Method=Full
By all means, if I am wrong could someone please correct me!
Kevin
-----Original Message-----
From: David Mathieu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 7:44 AM
To: Fusebox
Subject: Re: newbie Oracle Stored Procedure
I think the @ needs to go and be replaced with an &
--- Kevin Bridges <[EMAIL PROTECTED]> wrote:
> I'm trying to create and run a stored procedure in
> Oracle that accepts one
> parameter from cf, runs a select statement with that
> parameter, and then
> output the results of the query on the cf side ...
> I'm keeping it simple so
> I can get a grasp on the mechanics.
>
> As you can see in the code below I am stuck between
> SQL server and Oracle
> and am quite confused since I've never done this
> before! Any help is
> appreciated.
>
> On CF Page:
>
> <cfstoredproc datasource="kbridges"
> procedure="sp_colections_by_franchise">
> <cfprocresult name="test">
> <cfprocparam type="in" dbvarname="@ID"
> value="1520"
> cfsqltype="CF_SQL_Numeric">
> </cfstoredproc>
>
> <cfoutput query="test">
> #FRU_UID#
> </cfoutput>
>
> In Stored Procedure File:
>
> CREATE OR REPLACE PROCEDURE
> sp_collections_by_franchise(
> @ID IN NUMBER)
> AS
> BEGIN
> SELECT FRU_UID
> INTO FRU_UID
> from fru
> where fru_uid = @ID;
>
> END sp_collections_by_franchise;
> /
>
>
>
> Here was my error message:
>
> Oracle Error Code = 6550
>
> ORA-06550: line 1, column 35: PLS-00103: Encountered
> the symbol "@" when
> expecting one of the following: ( ) - + mod not null
> others table avg count
> current exists max min prior sql stddev sum variance
> execute multiset the
> both leading trailing forall time timestamp interval
> date The symbol "" was
> substitute
>
>
>
> SQL = "sp_colections_by_franchise"
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
