ORA-01006: bind variable does not exist

[Guest]

I have an Oracle package with 2 procedures. The 1st one is just an insert statement and the 2nd one takes care of updates/deletes.

I can run the 1st one without any problem. But on the 2nd one, I keep on getting ORA-10006 error on the variable "p_return_code" if I ran it using Coldfusion.

I have checked the variable names several times and as you can see, the 1st "p_return_code" is exactly the same as the 2nd one. But the 2nd procedure just won't run.

I can compile the package without any problems. and I can run the 2nd procedure from an Oracle client without any problems.

Any ideas?

Please see the code below. Thank you.
========================

[CF_Oracle]

Please put code of 2nd procedure. Also, how did you provide IN parameters when tested in Oracle? What are their source in ColdFusion?

[paross1]

Since you are declaring the OUT parameters in your PL/SQL as type INT (ANSI), which is actually a subtype of Oracle type NUMBER, you might try using CFSQLType = CF_SQL_DECIMAL instead of CF_SQL_INTEGER. Not sure if it will make a difference, but I'd give it a shot. (Also, you don't need the variable attribute in your cfprocparam tags for type="in", as this attribute is only required for OUT or INOUT types. )

Are any of your IN parameters NULL?

Phil