Search results for query: *

For anyone who find the same thing, I have now tracked this down to how much other code is previously in the procedure. For some reason, DBA studio was substituting a :1 for a question mark when there were 10 table updates before the redirect (owa_util, but it also did the same thing with an...

Hi We use pl/sql packages to interact with an 8.1.7 db, and every now and then it replaces question marks in owa_util redirect_url statements with ':1'. The package is valid in PL/SQL still (the :1 basically being html), and although you can compile the packages having subsituted a "?" and in...

Thanks Guys - much appreciated. Sid

Thanks very much for your efforts Mufasa - especially given the time in the morning. Kind regards, Sid

Thanks for that Mufasa If the SQL was: select a.country,count(b.country)Count from country a, Organisation_type b where a.id = b.country(+) and b.type='reseller' group by a.country Could you do something similar? Kind regards, Sid

Sorry! Basically, I think my problem boils down to: Country table: ID Country 1 UK 2 US Organisation_type table: Country Type 1 Reseller 1 Reseller Select country.country, count(ot.type) from organisation_type ot, country where ot.country = country.id group by country.country...

Hi Mufasa On the sample of table contents, the user can select any table from a web page drop down box, and then the fields that relate to the table they have selected are displayed in another drop down box. This is done 3 times, one for the values that are needed in the rows (row_name and...

Hi - I suspect this is a basic SQL issue. I'm trying to create a crosstab from three sets of tables and fields that are selected by the user. 1, the columns, 2, the rows and 3, the values. I am using a three dynamic SQL cursors, one after the other, to show: First, the columns (simple group...

Hi - I'm trying to log onto our database server using Enterprise Manager. This is something I have been able to do without a problem before. But, we have changed our IP addresses. I am logging on using the IP address, the port, and the database name. I am getting the TNS error code noted...

Thanks - will look into this, but perhaps I could use that idea and sendkeys from the VBA script (if VB still does this!). Perhaps worth a try... Regards, Andrew

Thanks Matt - I'm not running Outlook on Exchange, but will try the ideas behind the faq and and see if they work! Regs, Andrew

I had a VBA/VB script that sent HTML e-mails to Outlook 98 to my customers, and I have now had to install Outlook XP. This seems to have Outlook security update automatically applied, and each time I try and use my VBA script, Outlook does the 'You are trying access...' dialogue, followed by a...

Hi I had a VBA script that sent HTML e-mails from Access 97 to Outlook 98 to my customers, and I have now had to install Outlook XP. This seems to have Outlook security update automatically applied, and each time I try and use my VBA script, Outlook does the 'You are trying access...'...

Hiya To date I've created several apps with small numbers of users. In the system I have used, each user has a separate user account in Oracle 8.1.5 and the username is fed through to access to different levels of data using the USER. I've used raw webdb reports and forms, and PL/SQL scripts...

A customer has sent me some files he has exported (actually SQL outputs) from 8i. He says he has delimited them with a semi-colon, but they are effectively fixed-width. The records are padded with spaces. This has made the files massive - one of them is 2GB, others are around 1GB - they should...