[DFW CFUG] ORACLE Stored Procedures

Thu, 19 Jan 2006 07:07:03 -0800

Title: Glacier
I have a simple Oracle Stored procedure:
 

CREATE OR REPLACE PROCEDURE "AYB001"

(our_recordset OUT SYS_REFCURSOR)

AS

BEGIN

OPEN our_recordset FOR

SELECT *

FROM T_DEPT;

END;

/

It returns a recordset and works when tested from TOAD, but when I try it from CF with this:
 
<cfstoredproc procedure="MYSCHEMA.AYB001"
 datasource="***" username="***" password="***">
 <CFPROCRESULT NAME="HOLDER">
  </cfstoredproc>
 
 
I GET:
 

Error Executing Database Query.

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to &apos;AYB001&apos; ORA-06550: line 1, column 7: PL/SQL: Statement ignored
 
Getting frustrated with this.  Anyone encountered this before?
 
Oracle 9i (Not sure on driver, but assuming the default)
CFMX 6.1 Enterprise (6,1,0,83762 With Updater)
 
 
---------------------------------------------------
Galen M. Smallen
Senior IT Systems Analyst
Quality Data Systems
Bell Helicopter-Textron
 

 

 
_______________________________________________
Reply to DFWCFUG: 
  [email protected]
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.HostMySite.com 
  www.teksystems.com/

Reply via email to