PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Oracle Stored Procedure and cfstoredProc
Date: Thu, 13 Dec 2001 14:22:34 -0500
All,
Is it possible to pass a parameter into an Oracle Stored Procedure to
limit the record set that is returned but the procedure
Troy,
Are you getting an error when you try and run the procedure? What version
of CF/Oracle and what happens when the IN parameter is used? I've been
successful using CF5/Oracle 8.1.6 to pass in parameters.
dave
At 10:38 AM 12/14/2001 -0500, you wrote:
All,
I should have been more clear
Dave,
I'm using Oracle 8.1.7 with CF 4,5,1, SP2.
I get the following error:
Oracle Error Code = 6550
ORA-06550: line 1, column 48: PLS-00312: a positional parameter association may
not follow a named association ORA-06550: line 1, column 7: PL/SQL: Statement
ignored
SQL = Portfolio.Get_Branch
Troy,
In your cfprocparam tag, you must either use dbvarnames in all the
cfprocparam tags or in none. So in line 2, add in dbvarname=p_Branch and
you should be ready to rock and roll.
cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=p_ObjPK
value=34 null=No
cfprocparam type=Out
All,
New Error:
I thought I would create a test procedure and now I am getting this error. The
Procedure works correctly outsize of ColdFusion. I use Oracle SQL*Plus
command line tool to test it.
What could be causing the problem.
This has become very irriatating. UUu!!!
Oracle Error
All,
Is it possible to pass a parameter into an Oracle Stored Procedure to
limit the record set that is returned but the procedure? If I remove
the IN Parameter from the Oracle Stored Procedure, it works fine. But
I do not want all the records. I just want a return a set of records.
I appears
cfprocresult has a maxrows attribute
cfprocresult name=smellyCheese maxrows=20
hope this helps,
-chris.alvarado
[application developer - 4 Guys Interactive]
From: Troy Simpson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Oracle Stored Procedure
7 matches
Mail list logo