that error means you're either, sending too many or too few parameters, o r you're not returning any parameters to your stored procedure...
are you creating a function or a stored procedure? Your code says functi on, but you're saying stored proc. you should be creating a procedure not a function. if i remember correct ly a function will not return a recordset. you are inserting into a cursor. i would assume that you want to use the cursor so you can loop through your records to manipulate something. anyway, i hope this helped. ----- Original Message ----- From: "Eric Gilbert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 11:41 PM Subject: Oracle 8i and cfstoredproc confusion > Hi all, I've gotten my self twisted around on the correct way get a res ult > set back from an oracle 8i procedure ..... This is my first real attemp t 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 resu lt > 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 argumen ts > 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.cursorTyp e > 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 > ______________________________________________________________________ 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=coldfusiona 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
