You can only call stored PL/SQL procedures from Oracle using CFSTOREDPROC
, not
stored PL/SQL functions. Also, RETURNCODE has to be no for Oracle.
Regards,
Joel Parramore
-Original Message-
From: Eric Gilbert [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 11:42 PM
To:
I also seem to remember that returncode=yes will throw things. Try taking
that out.
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
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
3 matches
Mail list logo