Search results for query: *

Garan, Thank you so much for the solution. Have a Happy New Year. getjbb

Garan, Thanks you for the response, but I do not have the privilege to change the date format. Is there a way of getting around setting NL-DATE-FORMAT? Perhaps another way to get the needed results. Thanks, getjbb

Could someone please help me. I need to concatenate two fields, date and time. I tried the following: DECLARE v_date DATE := to_date('09-MAR-2015','DD-MON-YYYY'); v_time VARCHAR2(6) := '050520'; v_full DATE; BEGIN v_full := TO_DATE(TO_CHAR(v_date, 'DD-MON-YYYY')...

It was my understanding that a JS Object, which Xmldoc is, was not the same as JSON. My problem is that the web service I am using only accept XML file, but my final data has to be in the JSON format in order for me to use it, therefore I cannot use the JS Object of Xmldoc, unless it can be...

Hello, I have am new to Javascript(Dojo) and I need to create a JSON Array from XML data coming back from an AJAX call. I do not know what to do after parsing the incoming data and assigning it to an XMLDOC var: var XMLDOC = dojox.xml.DomParse.parse(data); I am trying to keep from having to...

Thanks, Dagon

I am using 9i: My problem is I am trying to return a table from a function, but I am getting the following error: ORA-06550: line 2, column 36: PLS-00302: component 'GET_TAB_PRODS' must be declared ORA-06550: line 2, column 10: PL/SQL: Item ignored ORA-06550: line 8, column 3: PLS-00320: the...

Sorry, forgot subject line, again.. I have a string: ,off,on,off I want to parse the data into an array. I found and tweaked (bolded) the following code, but the result was: <blank line> (think this is coming from the first ',') off on off ---------------------------------------...

I have a string: ,off,on,off I want to parse the data into an array. I found and tweaked (bolded) the following code, but the result was: <blank line> (think this is coming from the first ',') off on off --------------------------------------- FUNCTION SPLIT (p_in_string VARCHAR2, p_delim...

Thank you all so much. getjbb

I am getting back the error: Missing ; before statement chkBox.innerHTML = "<input type=checkbox onclick=is_checked() id="cbox + index" name="cbox + index">"+field1+""; And it is pointing to the cbox that is bolded. Whatever help given will be appreciated. The piece of code is within a...

Sorry forgot a Subject... I am not no sure this is the correct forum to be asking this question or should it be asked in the Oracle forum since it relates to htp.p but.... I am trying to pass an array from a JavaScript function to an Oracle stored procedure: var g_check_ids = ; var g_on_off =...

taupirho -- Thank you so much, I was able to use your code. getjbb

Actually it has to be in the where clause of a select statement. The result ('Y' or 'N') is being compared to a database field: WHERE DECODE(database_field, NULL, 'N','N','N','Y') = DECODE(incoming_param,'I', 'Y', 'E', 'N', 'A', 'Y' or 'A', 'N') getjbb

'A' is a parameter coming into a procedure, which is a value set from one of three radio buttons ('I' (Include), 'E' (Exclude), 'A' (All) ). The values of 'Y' and 'No' are being compared against each field within a cursor select. If 'A' is not 'N' or 'Y',which mean it is NULL it should be set...

DECODE(database_field, NULL, 'N','N','N','Y') = DECODE(incoming_param,'I', 'Y', 'E', 'N', 'A', 'Y' or 'A', 'N') if incoming_param = 'I' then 'Y' elsif incoming_param = 'E' then 'N' elsif incoming_param = 'A' then <I want the be able to capture a row if it is either 'Y' or 'N' when...

How can I use decode where a value can be either yes or no: DECODE(some_variable, NULL, 'N','N','N','Y') = DECODE('E', 'I', 'Y', 'E', 'N', 'A', 'Y' or 'A', 'N') In other words if the value if 'A' I want rows where a certain field has 'Y' and 'N' getjbb

Thank you so much, LKBrwnDBA. This helps a lot.

If I have an associative array as follows: bookkeeping(EXAM1) := 'Inventory'; bookkeeping(EXAM2) := 'Accounts receivable'; bookkeeping(EXAM3) := 'Inventory'; bookkeeping(EXAM4) := 'Property, plant and equipment'; bookkeeping(EXAM5) := 'Assets'; bookkeeping(EXAM6) := 'Accounts receivable'...

feherke- What I meant by it did not work is when I the function was called the value was not set to on or off. I took out the period after the form name (theform) and now it work (Thanks). I change the value checkbox value because I need to know what the value is further down in my code to...