Hi all, I've gotten my self twisted around on the correct way get a result
set back from an oracle 8i procedure ..... This is my first real attempt at
this and based the code on what I gathered from other CF-Talk posts of a
similar topic. I think the problem is with the procedure, but the result
set seems to come back just fine in Oracle SQL*Plus. Any help on this is
greatly appreciated. It gets the following message when I run the code in CF5:
the error is :
ORA-06550: line1, colum 13: PLS-00306: wrong number or types of arguments
in call to 's_departement_get_all' ORA-06550: line 1, column 7: PL/SQL
Statement ignored
the CF code is:
<cfstoredproc procedure = "s_departement_get_all" dataSource =
"#request.db.dsn#" returnCode = "Yes">
<cfprocparam type = "Out" CFSQLType = "CF_SQL_REFCURSOR" variable =
"testingoutvar"> <cfprocresult name = "rs1" maxrows="-1">
</cfstoredproc>
and finally the script for creating the sproc:
create or replace package types
as
type cursorType is ref cursor;
end;
create or replace FUNCTION s_departement_get_all return types.cursorType
as
l_cursor types.cursorType
begin
open l_cursor for
select name, date_created
from department
where date_created > sysdate
order by name;
return l_cursor;
end;
Thanks in advance, Eric
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
