cfstoredproc

Accessing RAISEERROR message from cfstoredproc

Hi there, I have a SQL stored procedure which under some situations will return a result of -1 if it fails, but also returns a message via the RAISERROR command e.g.: BEGIN RAISERROR ('Error %i has occurred', 11, 1, 0) RETURN -1 END I am accessing this via coldfusion using cfstoredproc e.g.: <cfstoredproc procedure="sp_ret...

What is a bound variable?

There is a cffunction (in a cfc document) which authenticates a user. It references a stored procedure and has a cfprocparam which is of type "out". On the Adobe CFML reference it says that means that "the parameter is used to receive data from the database system only. Passes the parameter as a bound variable." What is a bound variable...

array or list into Oracle using cfprocparam

I have a list of values I want to insert into a table via a stored procedure. I figured I would pass an array to oracle and loop through the array but I don't see how to pass an array into Oracle. I'd pass a list but I don't see how to work with the list to turn it into an array using PL/SQL (I'm fairly new to PL/SQL). Am I approaching ...

no statement parsed and wrong number or types of arguments - cfstoredproc

I have an Oracle procedure - editBacklog which I'm calling from a CFM page via cfstoredproc. After several changes to the procedure I started getting ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'EDITBACKLOG'. I've gotten this before and found that if I changed the name of the procedure it start...