I've checked in SQL Logs that the value of my current_field is being passed on fine to the "select Get_Hast('current value') from dual;". Doesnt look like null value is a problem,
as the Filter qualification itself filters out null values. checking out other suggestions on the thread. On Nov 5, 12:10 am, "Grooms, Frederick W" <[EMAIL PROTECTED]> wrote: > You may want to default the value in your get_hash function in Oracle > > Try something like > CREATE OR REPLACE FUNCTION GET_hash (in_value VarChar2 := > 'somedefault') return VarChar2 is > for your function definition > > This way if Remedy does not have a value for current_field when you call > the function it will use the default value > > Another thing you may look at is to see exactly what Remedy is sending > to the database by looking in the SQL logs. > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Wallace, Kelvin > Sent: Tuesday, November 04, 2008 12:25 PM > To: [EMAIL PROTECTED] > Subject: Re: PL/SQL function call via set fields. > > Hey B, > > I think this is the same error I get whenever an attempt is made to use > the SELECT on the first attempt. But, it works on the second attempt > and every other attempt until Remedy server is restarted. The Oracle > error is basically saying that Remedy is not defining the variable > before it is getting to Oracle. > > HTH, > Kelvin > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears > Sent: Tuesday, November 04, 2008 1:16 PM > To: [EMAIL PROTECTED] > Subject: PL/SQL function call via set fields. > > Greetings , > > we've a small function in Oracle 10g to return a transcoded/hashed > value for its input parameter., and are trying to use it for setting > the transcoded values into the DB. > > we're running ITSM 7.0 > > my filter Set Fields SQL looks like this -> > > select get_hash('$current_field$') from dual; > > the return value is assigned to the current field -> > > current_field = $1$ > > But whenever the filter is triggered, I see the following error. Any > idea how to get this fixed? > > "ARERR [552] Failure during SQL operation to the database : ORA-24374: > define not done before fetch or execute and fetch" > > My sqlplus prompt gives the correct response value for the function > call using the select statement. > > BnB > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"