[thelist] Oracle - Error on Insert But Not update? wah?

[Mark M]

For those that cared - changed it from a function to a procedure, and it
works fine now.

Weirdest thing I've ever seen, as I use functions all over the place.

Mark

------------------------------------------------------------------
mark at safefrombees.com
ICQ: 3094740
Safe From Bees
[ www.safefrombees.com ]
 

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On
> Behalf Of Plunkett, Matt
> Sent: Friday, 27 June 2003 12:02 AM
> To: 'mark at safefrombees.com'; 'thelist at lists.evolt.org'
> Subject: RE: [thelist] Oracle - Error on Insert But Not update? wah?
> 
> 
> 
> -----Original Message-----
> From: Mark M
> Sent: Wednesday, June 25, 2003 8:48 PM
> To: thelist @ lists . evolt . org
> Subject: [thelist] Oracle - Error on Insert But Not update? wah?
> 
> > I have 2 stored procs for dealing with a table, one to insert data,
and
> one
> > to update the data.  The procs are called from ColdFusion MX.
> 
> You have a function and a procedure.  I've never called a function
from
> ColdFusion. I would definitely try converting it to a procedure and
see if
> that helps.  Also, you may want to consider declaring your variables
based
> on the columns they represent like so:
> 
> FUNCTION insertData (
> 		  t_lnkrequestid IN TBL_REQ_DATA.lnkrequestid%TYPE,
> 
> 		  t_lnkelementid IN TBL_REQ_DATA.lnkelementid%TYPE,
> 
> 	                  t_value IN TBL_REQ_DATA.data_value%TYPE,
> 
> 		  t_ischanged IN TBL_REQ_DATA.data_ischanged%TYPE,
> 
> 		  t_versionnumber IN
TBL_REQ_DATA.data_versionnumber%TYPE
> 
> 	               ) RETURN NUMBER
> 
> Is your problem only when you call it through ColdFusion?  Can you run
the
> function with the problem data from Oracle?
> 
> Matt
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> Evolt.org conference in London, July 25-27 2003.  Register today at
> http://evolt.org.uk
> 
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !