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

    can't start dbconsole

    The fact that your service is absent is telling. I take it you're on Windows if your using DBUA? Can you 'tnsping' the DB OK? Drop the configuration files and repository with the following at the command prompt: emca -deconfig dbcontrol db -repos drop then run this to create afresh: emca...
  2. kutz13

    Moved to Virtual environment - 27101 error

    What state was the Oracle instance in when you imaged the server - shutdown completely, open, mounted etc? I've had this a few times on MS server 2003 R2, more often than UNIX/Linux anyway, and normally a restart of the Oracle services or m/c reboot resolves things. Check the specs of the...
  3. kutz13

    v$session request

    Try using the dictionary view 'v$sqltext' by searching on the SID from 'v$session'. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:13948258923206 will give you a bit more of an insight into tidying the output up. The difference between eggs and bacon: The chickens involved...
  4. kutz13

    Number rows incrementally based on previous row

    If the list of events is small, you might consider a before insert trigger on the first table which calls the nextval in a sequence. You may have a sequence for each event and wrap things up in a function which is called by the trigger. The difference between eggs and bacon: The chickens...
  5. kutz13

    National Character Set

    Not aware of any NLS_LANGUAGE support specifically for UK, 'ENGLISH' is the best you'll get. However, if you set NLS_TERRITORY to 'UNITED KINGDOM' you also implicitly define the following parameters: NLS_NUMERIC_CHARACTERS, NLS_CURRENCY, NLS_ISO_CURRENCY, NLS_DATE_FORMAT...
  6. kutz13

    Moving 9i Database to New Server

    John As it happened we exported our live Db and imported into a blank DB on the 10g server. It was fairly small (30GB), so this was adequate for what we wanted to do. Sorry about the original 'mk2' reference, I was referring to the 'new' instance on the 10g server.
  7. kutz13

    oracle developer 6i triggers

    Liz What exactly are you interested in finding out?
  8. kutz13

    ORACLE Tables' Ralationship

    You could try looking at TOAD Data Modeler: http://www.toadsoft.com/toaddm/toad_data_modeler.htm
  9. kutz13

    Moving 9i Database to New Server

    John We've just done the same. We named the new server as per the old one for simplicity, we have a number of systems connecting to this server and instead of amending all the tnsnames files this was easier. We didn't have any issues as long as you only have one visible on the network at a...
  10. kutz13

    Heterogeneous Services help needed

    ...INTEGER; val1 VARCHAR2 (100); BEGIN c := DBMS_HS_PASSTHROUGH.open_cursor@sqlserver; DBMS_HS_PASSTHROUGH.parse@sqlserver (c, 'select * from table1'); LOOP nr := DBMS_HS_PASSTHROUGH.fetch_row@sqlserver (c); EXIT WHEN nr = 0...
  11. kutz13

    Application.Quit 'event'

    Thanks Combo for highlighting 'Add-ins', I removed all except the ODBC add-in and everythings doing what I expected!
  12. kutz13

    Application.Quit 'event'

    No, the error is generated on a standalone workbook being closed via the application.quit event. The code set to run at workbook close still runs sucessfully, it's just that the error dialogue confuses users and I'd like to suppress it if possible.
  13. kutz13

    Application.Quit 'event'

    I'm hoping someone out there can help. I have an Excel workbook (2002) which runs many queries & procedures against remote ADODB connections using VBA. Using the 'Workbook_BeforeClose' event I'm able to remove sensitive data & save prior to closure. On the user quitting the app, instead of just...
  14. kutz13

    Returning Report Users Log-in

    Thanks for the link. Having never created a SQL Expression field in CR - is it as simple as 'SELECT user FROM dual', or is there specific syntax that I need to follow?
  15. kutz13

    Returning Report Users Log-in

    We're using CR8.5 to create reports in an application using an Oracle 8i DB. At run-time the reports are using the currently logged-in users credentials. Is there a way to return the logged-in username to a Crystal Report along the 'SELECT user FROM dual' function in Oracle?
  16. kutz13

    DateDiff formula query

    That did the trick - thanks for the help lbass
  17. kutz13

    DateDiff formula query

    The formula in full is: if {table.startdate} < {D1} and {table.enddate} <= {D2} then DateDiff("d",{D1},{table.enddate}) else if {table.startdate} >= {D1} and {table.enddate} <= {D2} then DateDiff("d",{table.startdate},{table.enddate) else if {table.startdate} < {D1} and ({table.enddate} > {D2}...
  18. kutz13

    DateDiff formula query

    I'm using CR8.5 against an Oracle 8 DB procedure and need help with the following if possible. Data records contain a start date and an end date(say D1 & D2), I need to include all records that have an end date that is either Null or ends within user defined period(start & finish), I then need...
  19. kutz13

    Calculating age in period

    Yep - that appears to do it. Thank you
  20. kutz13

    Calculating age in period

    I'm hoping that someone here will help me with a formula needed for a report. Currently using CR8.5 & Oracle 8. The criteria for the report states that only individuals who attained the age of 16 within a given period will be included within the report. I can calculate age as of current date...

Part and Inventory Search

Back
Top