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
