Recent content by llmclaughlin

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

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

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

Ok, Thanks Louie

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

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

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

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

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(?,?)}"...

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

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

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

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

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

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