Search results for query: *

Hi Steve, When I get this error, its usually caused by two things: 1. The table, function, package or procedure that the synonym refers to has been deleted. 2. The user that is attempting to access the table, func.., etc has had their privileges removed. So, try a. check that the view still...

Hi Folks, Im using Report Builder 6.0.8.18.0 on a Win XP home machine. I have a drill down button defined on a report with it's font set to Arial 8. However when I preview the report (or exit developer and run the report) this button changes to Courier New 12. Any help would be appreciated on...

Hi Rob, Have you mapped the LOV columns? i.e. go into the properties of the LOV, and click on "Column Mapping Properties". Each column in the LOV that has a value you want returned must be mapped to a field on the form (the 'Return Item' box in column mapping). Jeremy

Hi, We are currently developing a 6i application and have run into a lot of minor bugs with the version you are using: labels disappearing, application crashing after exit_form, etc. I don't know if this will help with your issues, but I would recommend upgrading to the latest stable version of...

Hi, I am designing a Developer6i system for use across a range of platforms (NT desktops, NT laptops, Citrix, and very old laptops with Citrix). The system works perfectly, but on the old laptops the mouse pointer is almost impossible to see; white pointer against a light grey background. We...

Hi Carp, Thanks for your reply. I was hoping to be able to avoid testing if the records were already in tblA: i.e. Update....(select from tblB where id IN tblA) Insert....(select from tblB where id not in tblA) Just laziness really. Think I'll have to cursor it, and actually write some...

Is it possible to have an Update statement in Oracle 8i that doesn't detail all the field names? e.g. UPDATE tblA SET ROW = (SELECT * FROM tblB WHERE tblB.id = 1) WHERE tblA.id = 1; tblA and tblB have the exact same structure. I found a reference to 'SET ROW' in a 9i manual, but when I try it...

Assuming you're using Developer6i, have you looked at using the Forms Server/Forms Internet Server? We have moved a couple of large data/transaction volume billing systems onto these and found performance improvements (especially on the reports side). As all the code is server based, rolling out...

Hi, I have a screen which displays 15 records (out of a possible 100,000). The user is able to change the Sort order and filtering of these records by selecting from dropdown lists on the top of the screen. After a re-Sort, I want to bring the user back to the record they had selected before...

Hi Jordi, Thanks for your reply. We just managed to solve it ourselves by using a variable and changing the scope: <xsl:variable=&quot;allowedItem&quot;> <xsl:for-each select=&quot;./allowedUserRole&quot;> <xsl:for-each select=&quot;./authority&quot;> <xsl:choose>...

Hi, I've been trying all day to get the following code to work and keep on encountering problems - is there a better way of doing it? I have a Menu node which contains an allowedUserRoles node. This sub-node may have multiple authority/role attributes. I pass in an authority parameter to the...

Hi, the following should work - use MAX ROWID to get the last record: SELECT a,b,c,d FROM t WHERE rowid = (select max(rowid) from t); ROWID is an indexed field, so this shouldn't take too much processing. Regards, Jeremy

I would have thought that a simple select like the following would return the t1/t2 rows which violate the unique constraint: SELECT t1.a, t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b = t2.b AND t1.c = t2.d; Regards, Jeremy

Or create an icon on your desktop with the path pointing to SQLPLUS and the 'open in' folder pointing to whichever one you want to pick up your files from.

You can also use the package DBMS_SESSION for running these statements from within PL/SQL: -- This package provides access to SQL &quot;alter session&quot; statements, and -- other session information from, stored procedures.