Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: getjbb
  • Content: Threads
  • Order by date
  1. getjbb

    Concatenate Date and Time fields

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

    I need to create a JSON Array from XML Data

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

    Object type returns error

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

    Convert string to an Array

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

    I have a string: ,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...
  6. getjbb

    Error Message: Missing ; Before Statement

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

    Call an Oracle Stored Procedure From a Javascript Function

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

    Using Decode

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

    Looping through an Associative Array

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

    For Loop to access checkbox name

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

    Call Decode Result In a Function

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

    Oracle Error

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

    UpdateBlob not updating Oracle Blob field

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

    Saving value from Select tag

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

    Host Bind Array Too Small and Formatting

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

    Matrix

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

    Manipulating Oracle Parameters

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

    Remove Special Character

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

    Fetch Into

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

    Global Variables

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

Part and Inventory Search

Back
Top