Search results for query: *

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

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

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

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

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

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.

Liz What exactly are you interested in finding out?

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

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

We're using HS from an Oracle 10g instance to connect to a SQL server 2000 instance. We can use a 'select' query to find single values from a result set, but how do you return entire multiple rows? The syntax we use for single values is: DECLARE c INTEGER; nr INTEGER; val1...

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

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.

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

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?

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?

That did the trick - thanks for the help lbass

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

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

Yep - that appears to do it. Thank you

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