All I had to do is change the null="yes" to null="no" or remove the null
attribute.
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="p_str"
value="#v#" null="yes">
When the attribute null="yes" then you get a very very ambiguous error
message like this:
Message Error Executing Database Query.
Detail [Macromedia][Oracle JDBC Driver]Unsupported data conversion.
That took me about 5 days to figure out. What a was of time.
Troy
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]