Title: Message
|
I'm not good enough with Oracle to answer, but you might try using just a
CFQUERY and put whatever you have working inside of TOAD into the CFQUERY and
see if it runs...
ie..
<CFQUERY>
execute/call
AYB0001
</CFQUERY> or
whatever
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 'AYB001' 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
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/
