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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by llmclaughlin

  1. llmclaughlin

    Oracle Enterprise Manager 11g

    Having a sporadic and unpredictable problem logging into OEM via web browser.The database is up and running not the problem, it's that sometime I can go to the OEM and login and sometimes I can't. I enter username and password and it will just sit there and never leave the login page. When it...
  2. llmclaughlin

    Get a ref cursor from within another procedure

    I have procedure which returns a ref cursor like. PROCEDURE DEST_WORK_LIST_DATE (outCURSOR OUT OUTPUTCURSOR) IS BEGIN OPEN outCURSOR FOR SELECT u_worklist_date, u_worklist_increment FROM u_worklist_user WHERE TRUNC (u_worklist_date) = TRUNC (SYSDATE)...
  3. llmclaughlin

    Getting number of days from date

    Using the below code I'm coming up one day short. From todays date 8/20/2011 is 54 days, the below gived me 53. Any suggestions? Dim sNOW As DateTime = Now.ToShortDateString Dim sDATE As DateTime = CType("08/20/2011", DateTime).ToShortDateString Dim tSPAN As...
  4. llmclaughlin

    Analyze table

    Ok, Thanks Louie
  5. llmclaughlin

    Analyze table

    After running "analyze table ALIQUOT compute statistics;" it practically took down the server, no queries would work against the table. Had to reboot server to get things to work again. Any ideas on what could cause this just by running the statement. Thanks Louie
  6. llmclaughlin

    PLSQL Exceptions

    I just want to know with the code below is there a way to to get the line number. I do use Toad while debugging, if there is a way to get just for that, then that will do. EXCEPTION WHEN OTHERS THEN err_msg := substr(SQLERRM, 1, 200); fileHandler :=...
  7. llmclaughlin

    PLSQL Exceptions

    Is there a way to get the line number where the error occured? Louie
  8. llmclaughlin

    Recordset not editable

    This how to make a oracle recordset from cursor updateable. Set rsWorkflow = New adodb.Recordset Set adoCmd.ActiveConnection = adoConnection adoCmd.CommandText = "LIMS.ALIQUOT_WORKLIST.PlateWorkFlow" With rsWorkflow .CursorLocation = adUseClient .Open...
  9. llmclaughlin

    Recordset not editable

    What I'm doing is calling a cursor in an oracle stored procedure. when I try this With adoCmd .ActiveConnection = adoConnection .CommandType = adCmdText .CommandText = "{CALL LIMS.ALIQUOT_WORKLIST.get_PROBEVIALS(?,?)}"...
  10. llmclaughlin

    Recordset not editable

    Changing vb6 inline sql to stored procedures, having problem with query where the recordset needs to be editable. Below is current code: adoProbeVials.CursorLocation = adUseClient adoProbeVials.Open strSQL, adoConnection, adOpenDynamic, adLockBatchOptimistic, adCmdText New code...
  11. llmclaughlin

    Reading file in pl/sql

    Ok, thanks, I'll add it myself. Thanks again Louie
  12. llmclaughlin

    Reading file in pl/sql

    The last record in the file does not have a CR. If I go in the file and press enter on the last record, then yes, it does read all. But the file is written out by a third party program, which I have no control over in having them put in a CR after the last record. Thanks Louie
  13. llmclaughlin

    Reading file in pl/sql

    I've tried to use the external table, it works, but not for what I am doing. The trouble with the below code is if there is only one record in the file it will exit on the last string in the file, meaning it will not get the kit type. Any help. text file T61235,65499157588932185233756,SINGLE...
  14. llmclaughlin

    Reading file in pl/sql

    Yeah, the procedure wasn't creating the table is what I was talking about. It does now. Thanks again. Louie
  15. llmclaughlin

    Reading file in pl/sql

    Thats easy enough, thanks. I need to run it from within stored procedure, I tried CREATE OR REPLACE PROCEDURE TESTME(inFILENAME VARCHAR2) IS BEGIN EXECUTE IMMEDIATE 'CREATE TABLE ext_louie('|| ' PLATE_NAME VARCHAR(20),'|| ' FEDEX_BARCODE VARCHAR2(20),'|| ' KIT_TYPE...
See more

Part and Inventory Search

Back
Top