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 derfloh 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: *

  1. stevecal

    Here's an IDE for Ruby - Do you know of any others?

    Eclipse also has Ruby plug-ins.
  2. stevecal

    Maximum number of tables and performance issues

    We could probably squeeze a little bit more performance out of the system by generating empty tables from a sql script prior to the customer first accessing the system. We have looked at it and while it represents a hit, at the moment the (performance hit) : (effort required to modify this...
  3. stevecal

    Maximum number of tables and performance issues

    Actually, no it doesn't. We have volume (billing) data being generated for rapid (web) deployment and display, for which we have a number of dynamically created tables on a per account basis. These bill tables contain (potentially) large amounts of data (megabytes worth in some instances), and...
  4. stevecal

    Maximum number of tables and performance issues

    Hi, I am working on a database which potentially has a large number of tables. While I appreciate that Oracle theoretically supports an unlimited number of tables within a database, are there any known major impacts on performance or should I be looking to find ways to coalesce some of the data...
  5. stevecal

    Potential bug: reply to and Reply to all?

    I should have said that I am using MS Outlook 97 on a Windows NT platform....
  6. stevecal

    Potential bug: reply to and Reply to all?

    I have had a really strange thing and wonder whether anyone else has seen it where I have clicked "Reply To" in response to an email and it has generated a "Reply to All". Anyone else seen this?
  7. stevecal

    Run Time Error - Method not Found

    int sum = sumOfInts(testArray); in your main is an argument short of a full set: it needs to conform to your method prototype: public static int sumOfInts(int[] array, int index) and have an index passed to it as an arg.
  8. stevecal

    is there an SNMP package ?

    And if you want a Java SNMP stack & agent framework: http://i31www.ira.uka.de/~sd/mgmt/jmgmt/ should do the trick...
  9. stevecal

    How to get the IP Address of the Machine that is running the app?

    Don't know what ver. of PB you're using and I haven't done anything in anger with it for quite a while but if push comes to shove you could always run a shell command and pipe ipconfig to a file and read out of the file.
  10. stevecal

    is there an SNMP package ?

    http://edge.mcs.drexel.edu/GICL/people/sevy/snmp/snmp_package.html has what you need. Basic SNMP 1 & 2 support.
  11. stevecal

    Can Java Use Mysql for database ?

    thread269-395909 cover most of your bases for you...
  12. stevecal

    How do I get a Sybase table contents into an ascii file?

    I have a syb 11 db to look at tomorrow. I'd like to export a couple of the tables' contents to ascii for a trial upload to an Oracle db. What's the best way to do it? Help appreciated.
  13. stevecal

    run script on timer

    It depends. If you need it to run from external it depends on your operating system: with Linux/unix variants you'll use cron; with NT you'll use the AT command. Alternately you can use the Oracle internal dbms_job package to run timed jobs for you.
  14. stevecal

    Return Day of Week (spelled out)

    Yes, just have a simple table with values 1 - 7 in one column and the days in another column and select as necessary. This is an easy fix to that; what I suspect you really would like to do is get a day of the week for a given date, and this is how you do that: declare v_dow VARCHAR2(12); --...
  15. stevecal

    Array Passing in DarkBasic

    I had some fun and games last night in moving data between user functions which are arrays. There is no way of returning an array as a result of a function call. However you can use arrays by declaring your arrays as global at the top of your program; the values can then be accessed in any...
  16. stevecal

    Dropping/Recreating Sequences in Stored Procs

    Yes you can do it; but you need to execute this as dynamic SQL; the syntax for this will obviously differ dependant on the version of Oracle you are using.
  17. stevecal

    Session control between Oracle and Websphere

    NB: Oracle doesn't always tidy up open processes so you might want to run a Unix command like kill -9 <pid-id>. PS: You can get pid-id as follows: select vs.sid, vs.serial#, vs.status, vp.spid from v$process vp, v$session vs WHERE UPPER(vs.username) LIKE '%';
  18. stevecal

    Session control between Oracle and Websphere

    Jayaram, this might help you... Determine active/inactive sessions (and kill them…) SELECT sid,serial#,status,server FROM v$session WHERE UPPER(username) LIKE '%'; When you know the sid and serial# then you can kill them if you have sufficient privileges by passing the values of sid and...
  19. stevecal

    How can DBA see table of of other user ?

    But you can fake it by creating public synonyms for all the user's objects (you can do this with a spool script using: SELECT * FROM user.user_objects, etc), this saves you a) from prepending the username prior to the objects and b) will allow you to run packages, triggers, etc as though you...
  20. stevecal

    REF Cursor

    You need to do the ref cursor TYPE inside the package header rather than the body of your proc in order to make it externally available. Presumably you are trying to make the cursor available to something like e.g. a JDBC call, in which case you do not even have to loop it, just open the cursor.

Part and Inventory Search

Back
Top