Skip to main content
A
Anonymous
May 23, 2006
Question

ORA-01006: bind variable does not exist

  • May 23, 2006
  • 2 replies
  • 2475 views
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.
========================
This topic has been closed for replies.

2 replies

P
paross1
Participating Frequently
May 23, 2006
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
C
CF_Oracle
Inspiring
May 23, 2006
Please put code of 2nd procedure. Also, how did you provide IN parameters when tested in Oracle? What are their source in ColdFusion?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices