Search results for query: *

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')...

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...

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...

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 =...

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

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'...

I am trying to do a for loop function to validate a set of check boxes. The check boxes are named p_check with a number concatenated to it, which is called v_rows (p_check1, pcheck2, ext.) I would like to do a for loop without having to access each name separately. There could be many. An...

I am during a select with a couple of decodes included. How can I use the result (tr.trans_type) from the first decode in function call (SUBSTANCES.get_desc) in the second decode statement. SELECT TRANS_NUM, sub.ACCOUNT, TRANS_DATE, DECODE( (trans_num is null AND...

In Oracle 9i I am trying to assign variables declared as a string to a date field. I am getting the following error: ORA-01858: a non-numeric character was found where a numeric was expected The code is as follows: v_mnth VARCHAR2 DEFAULT NULL, v_day VARCHAR2...

I have the following updateblob statment in a NVO function, but it will not update a blob field in an Oracle 9 table: updateblob WPST.STATIC_FILE set FILE_CONTENT = :i_blb_filedata where ROW_ID = :li_row_id using SQLCA; if SQLCA.sqlcode < 0 then messagebox('ERROR', 'Error...

Is there anyway I can hold an old value and switch it with what the user is selecting, when they hit save, or revert back to the old value. Right now if I try to save I get the error that only one value can be saved at a time, into the table field. During the save I think the new value is...

I did not see a forum for SQLPLUS, so I hope this is the correct forum to post my question to. After running the following script (did not put in all columns, because it is too many): set termout on set echo off set feedback off spool &directory declare cursor get_fore is select fortype...

I am trying to create a matrix which should look like the following: one item dumplings salad chicken-fried chicken-grilled desert-cake desert-pie ----------- ------------ ------ ---------------- -----------------...

Is it possible to change a where clause condition according to a parameter coming into a package. The problem is that I have a proprietary package that cannot be changed. The package, currently, has a parameter called a_date that will need, eventually, handle a date range. A date range will...

How can I srip off special characters in PL/SQL? I have a message which has two small square boxes at the end of it. I do not know what special character these boxes relate to. When I cut and paste them they turn into '?'. I tried to remove them...

Using the command Fetch Into, is there a way to fetch selected fields into variables, when you do not know how may fields are in a select statement. In the future I plan on using whatever script I create, so I am trying to get the Fetch Into statement as generic as possible. Could I do this...

I have the following package and I not clear on how to use the parameters coming in from one procedure (Create_Auto_Data) to flow to another procedure (Get_Trans_Info) and function(Get_Max_RowNum) in the package. The params are date fields. Where the date is hardcoded as TO_DATE('06-22-2009'...