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
Try
CFSTOREDPROC procedure=WebInterface.IsBaseCaseComplete
and the rest as you have it.
-Original Message-
From: Andrew Middleton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 9:17 AM
To: CF-Talk
Subject: Oracle 8i and CFSTOREDPROC
I have a problem trying to call a stored
4 matches
Mail list logo