Recent content by mcgibbong

I need to set Dos Environment variables in PL/SQL. Can anyone let me know how to do this? Thanks

Yes I have 2 Oraclehomes.

Can anyone tell me how to determine which version of the Oracle8i client I have installed, as when I try to instal the ODBC driver from the CD it says that it cannot be installed on a 7.x or 8.0.x client?

I am writing a function that accepts the column name from all_tab_columns for any table and select the column data using this name. eg get the column name account_number which i know is in the accounts table, from all_tab_columns. I then want to select account_number from accounts. If I just...

I am trying to tidy up the users on the Oracle 8i server. Is there a way that I can find out when a user last logged on? The server is taken offline each night for an acrserve backup, so any session information before this seems to have gone.

Thanks again nagornyi, I'll try that.

I got the above while running a report in Oracle reports 6 on Oracle 8i. the help says delete it or add contents. The only problem id that in the object Navigator, when I try to delete ie, I get the above again. When I go into the layout model to delete or add text, I cant see it. Is there...

nagornyi, Thanks that sounds good.

I am using reports 6.0.8.13.1 running on Oracle 8i. I have a report that prints a schedule for each account, listing dates with a value against each, then when the account changes, a total is printed. I have put in the Page break after report property so that it throws a page after each...

I have a table accts in Oracle 8i from which I want to select cust and acctno. Each customer can have more than 1 acctno. So select cust,acctno order by cust,acctno from accts returns cust acct 1 989 1 990 2 010 2 011 2 012 3 001 4 800 etc. I can product a comma delimited file from this okay...

Sorry, thats what I meant to do!!

I have a table accts in Oracle 8i from which I want to select cust and acctno. Each customer can have more than 1 acctno. So select cust,acctno order by cust,acctno from accts returns cust acct 1 989 1 990 2 010 2 011 2 012 3 001 4 800 etc. I can product a...

Is there somewhere that the date/time last updated for an oracle table is held?

Try using the Ltrim and Rtrim on distr as there may be leading or most likely trailing spaces on the variable.

I got it sorted. It WAS the font!! In the printer properties there is a tick box 'use substitution table' or 'always send to printer' I ticked 'always send to printer' instead and all is well. Thanks to everyone for their help.