CF Claims Oracle Stored Procedure does not exist.
Hi Everyone,
Cold Fusion is telling me
Error Executing Database Query. | |
| [Macromedia][Oracle JDBC Driver][Oracle]ORA-06564: object CICOD.CI_GET_SUMMRPT_LANGUAGES.GET_LANGUAGE_PREFERENCES does not exist ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 | |
| The error occurred in /apache/www_dev_7084/bes-partners/Integrated Workforce Reports/language_preferences_report.cfm: line 41 | |
39 : <cfprocparam 40 : value="0" 41 : cfsqltype="cf_sql_numeric"> 42 : </cfstoredproc> | |
My Oracle package works fine when called from an Oracle procedue and I have verified that the CF user has privileges to the package.
My code is below.
Any suggestions?
Thank You in Advance for Your Help,
Lou
Cold Fusion
<cfstoredproc procedure = "CI_GET_SUMMRPT_LANGUAGES.GET_LANGUAGE_PREFERENCES" dataSource = "cicod_dev" >
<cfprocresult
name = "p_reply">
<cfprocparam
value="01-JAN-09"
cfsqltype="cf_sql_date">
<cfprocparam
value="01-APR-09"
cfsqltype="cf_sql_date">
<cfprocparam
value="1"
cfsqltype="cf_sql_numeric">
<cfprocparam
value="0"
cfsqltype="cf_sql_varchar">
<cfprocparam
value="0"
cfsqltype="cf_sql_numeric">
</cfstoredproc>
Oracle Package Declaration
create or replace
PACKAGE CI_GET_SUMMRPT_LANGUAGES
AS
-- see http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17938 Method 1: Reference Cursor Method
-- p_reply_cursor Oracle and ColdFusion coding.
TYPE p_reply_cursor
IS
REF
CURSOR;
PROCEDURE GET_LANGUAGE_PREFERENCES
(
p_reply OUT p_reply_cursor,
p_start_date IN DATE,
p_end_date IN DATE,
p_sum_column IN NUMBER,
p_region_selections IN VARCHAR2,
p_location_selection IN NUMBER) ;
-- Values for p_sum_column to determine which columns to SUM.
c_registration_reregistration CONSTANT INTEGER(1):=1;
c_served CONSTANT INTEGER(1):=2;
END CI_GET_SUMMRPT_LANGUAGES;
Oracle Package Body (Header Only)
PROCEDURE GET_LANGUAGE_PREFERENCES
/*
p_reply: . . . . . . . Cursor containing requested data.
p_start_date: . . . . . Start date of request.
p_end_date: . . . . . . End Date of Request
p_sum_column: . . . . . See GET_LANGUAGE_PREFERENCES.c_registration_reregistration
and GET_LANGUAGE_PREFERENCES.c_served.
p_region_selections . . Region selections to report, seperated by commas.
p_location_selection: . Location selection to report.
*/
(
p_reply OUT p_reply_cursor,
p_start_date IN DATE,
p_end_date IN DATE,
p_sum_column IN NUMBER,
p_region_selections IN VARCHAR2,
p_location_selection IN NUMBER)
AS
AdChoices