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: slok
  • Order by date
  1. slok

    network for small LAN and WAN

    I'm more of a software guy and is new to networking. Nonetheless, here is the situation now... == A small and very traditional company with a HQ office and 5 branch office. They are not networked at this point in time. HQ office have around 10 PC with no network. HQ also have 2 printers...
  2. slok

    sysdate displaying date and time

    how can I retrieve a sysdate value and display it in date and time? I have a simple table "test" with a field datetime and datatype date. I do an insert as follows: == insert into test values (sysdate); == now, I want to retrieve the value and use it to insert into another table...
  3. slok

    question on row locking

    when deleting from a record from a table... how can I lock it for delete. I tried something like that.. == select emp_no from employee where emp_no = '1' for delete nowait; == in SQLPlus, it gives me an error message === ERROR at line 1: ORA-00905: missing keyword == What could be wrong?
  4. slok

    SQLJ calling stored procedure with cursor?

    I have a stored procedure as follows: === Procedure Count_Offences ( p_sdate IN date, p_edate IN date, p_off_cur IN OUT OffencesCurTyp) AS BEGIN OPEN p_off_cur FOR SELECT DEMERIT_CODE, count(*) FROM offence WHERE off_datetime between to_date(p_sdate, 'YYYY-MM-DD') AND to_date(p_edate...
  5. slok

    ORA-01034: ORACLE not available on win2k

    ok, I am not sure whether this is the alert log. But I do find some form of log file at this location... C:\Oracle\admin\mugca\bdump\mugcaALRT.LOG "mugca" is my database instance. and the last entries in the log file shows 18 April. I have since rebooted the machine a couple of...
  6. slok

    ORA-01034: ORACLE not available on win2k

    where is alert log? thanks
  7. slok

    ORA-01034: ORACLE not available on win2k

    Also, from Toad, I got the following messages... ================ Details: oci.dll found 2) Oracle Home Key is SOFTWARE\ORACLE\HOME0 Looking for TNS_ADMIN environmental variable TNS_ADMIN environmental variable doesnt exist, looking for TNS_ADMIN reg key using home key...
  8. slok

    ORA-01034: ORACLE not available on win2k

    I got the following error while trying to logon via SQLPlus. I have check the services and only one is not started. ==== OracleOraHome81Agent Started Automatic OracleOraHome81ClientCache Started Automatic OracleOraHome81DataGatherer Started Automatic...
  9. slok

    procedure to return muliple rows?

    I have a table as follows and need a procedure to return, given a start date, end date, a count of all offences group by demerit code == Table stu_offences OFF_DATETIME NOT NULL DATE DEMERIT_CODE NOT NULL NUMBER(2) MOD_DATETIME...
  10. slok

    return value from procedure

    thanks
  11. slok

    return value from procedure

    ok, I have it as follows but still get error.. == 46/43 PLS-00103: Encountered the symbol ";" when expecting one of the following: return Warning: Package Body created with compilation errors. ==== My code is as follows.. == create or replace package my_pkg...
  12. slok

    return value from procedure

    how do I declare funciton inside a package? I'm having trouble declaring it inside a package.. == create or replace package my_pkg as procedure Check_Suspend ( p_stuID IN tableA.stuID%type); function Check_Limit ( p_stuID IN tableA.stuID%type); end my_pkg; create or replace package body...
  13. slok

    return value from procedure

    I have a procedure Check_Suspend and it calls another procedure Check_Limit. Check_Limit procedure is basically just a select statement base on its 'IN parameter' to add the total of a field 'sum(a). How can Check_Suspend 1. call Check_Limit 2. get the value of sum(a) from Check_Limit?
  14. slok

    query question

    query question for 3 tables... == Table Student Student_NO NOT NULL CHAR(10) NAME NOT NULL CHAR(30) STREET NOT NULL CHAR(20) POSTCODE NOT NULL CHAR(20) DOB...
  15. slok

    MTS and .NET

    what features does MTS (or other transaction monitor) provides that will enhance a typical 2 tier client-server system?
  16. slok

    update procedure

    given, if I have a table as follows: create table test ( fieldA date not null, fieldB char (6) not null, fieldC char (30) not null, fieldD char (10) not null, constraint pk_test primary key (fieldA, fieldB)) How can I write a update procedure where the update statement is dynamic...
  17. slok

    integrity constraint - foreign key not found?

    how can I do a delete with a CASCADE
  18. slok

    integrity constraint - foreign key not found?

    I have 2 tables as follows Table A DATETIME NOT NULL DATE REG_NO NOT NULL CHAR(6) .... constraint pk_a primary key (reg_no, datetime), Table Audit DATETIME NOT NULL DATE REG_NO...
  19. slok

    MTS and .NET

    I am new to MS products and how it fits the overall picture in terms of architecture. 1. What does MTS do? 2. What is MTS relation with respect to .NET or what role does it plays? 3. In creating or "giving new life" to a old product, I have a old system which is essentially...
  20. slok

    trigger and multiple procedure?

    whenever I insert/update/delete an employee_salary table, I need to 1. write to an audit table , procedure write_audit 2. check whether salary has reached limit, procedure check_sal I have 2 procedures to handle point "1" and point "2". But how can I do a trigger that will...

Part and Inventory Search

Back
Top