Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by vbdude13
-
I have an Oracle stored procedure b
I have an Oracle stored procedure being called by through <cfstoredproc>. I can run the stored procedure from "other" client side apps. When I run the procedure in CF, and pass CF_SQL_VARCHAR parameters with a size GT 23, the CF 5.0 Server "hangs". If I pass params LTE 23... -
Stored Procedure Problem
Correction to the procedure (I mistyped the END: PROCEDURE app_desc_check (p_description IN varchar2, p_list OUT app_table_rows) IS BEGIN OPEN p_list FOR SELECT DESCRIPTION FROM APP_CODES WHERE DESCRIPTION = p_description; END app_desc_check; Any help would be great. -
Stored Procedure Problem
I am using <CFSTOREDPROC>. Here's my CF code: <CFSTOREDPROC PROCEDURE="APP_PKG.APP_DESC_CHECK" DATASOURCE="#SESSION.DB#" USERNAME="#SESSION.USERID#" password="#SESSION.PASSWD#"> <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR"... -
Stored Procedure Problem
I am using CFServer4.5, CFStudio4.5.2 & Oracle8i. My problem is that I have a stored procedure that runs perfectly when the one and only param is 23 chars or less. As soon as I try pass a larger param, from a calling cfm, CF Server has trouble bringing up the action cfm the storeproc resides...
