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 at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
