This won’t help much I know, but I think the Key has to be a string so you may have problems when your data is not this type. Cheers M
View Answer | May 27, 2004 9:41 AM
Hi Carbon, They can be either depending on how you do it. Pass Through queries [harking back to MS Access] are where code is executed directly against the database using for example a Connection object to execute SQL strings. Direct access is when you work with an ADO recordset that you instantiate, manipulate and send [...]
View Answer | May 27, 2004 6:33 AM
I don’t happen to know of one specific to Ireland but I looked at a rather old list of Oracle links and user groups that I have and you could certainly go to www.uk.oracle.com which may have links to user groups in the uk. I also have www.oracleuser.co.uk as a user group link. If anyone [...]
View Answer | May 25, 2004 9:40 AM
The limit of the VARCHAR2 datatype (and presumably for CHAR as well) is indeed 4000 characters. If you need more, you can use CLOB, which is easily converted to/from VARCHAR2 or CHAR. On the other hand, CLOB columns cannot be indexed (AFAIK). Maybe you can define a function-based index on to_char(clob_column)… Regards, ActorJack
View Answer | May 24, 2004 9:44 AM
Hi, I’ve seen this type of thing before and have traced it in the past to permissions issues, however that is not to say that permission settings are always the problem! It might be worth considering.
View Answer | May 24, 2004 6:41 AM
I’ve noticed after modifying ESS screens to open a new window or having a print window pop up that it always failed for certain users. Turned out they had “Pop-up” blockers installed on their browsers which caused it to fail. Just a thought.
View Answer | May 19, 2004 9:56 AM
First, get a domain hosting site. I use www.1and1.com. They have PHP and MySQL included with the monthly charge. If you want to use Oracle, please be prepared to pay big bucks. Not only that, I don’t know of any that would host Oracle, but I don’t know them all. If you decide to host [...]
View Answer | May 18, 2004 5:25 PM
Implementation, Oracle, Web site design & management
Not intended as a non-answer, but have you considered _not_ advertising the database that’s backing your website? Is it just me, or are “powered by” graphics best left to corporations touting their own products or to open-source advocates upping their geek factor (and simultaneously advertising open-source)? I shy away from advertising the software I’m using, [...]
View Answer | May 18, 2004 10:27 AM
Using Front Page is okay, but bear in mind that if your ISP does not support Frontpage extensions, some of your functionality may be lost. Also, Frontpage doesn’t work on portals, as SAP, typically, actually use their own version of html.
View Answer | May 18, 2004 3:54 AM
Need to know what kind of Help file i.e. Windows (.hlp) or HTML (.chm). Also what programming language are you using.
View Answer | May 17, 2004 10:53 AM
I have used WinRunner software to create test transactions for GUI screens. This software is easy to use (made by the same company as LoadRunner) and is similar to recording Macros in Microsoft Excel.
View Answer | May 14, 2004 12:51 PM
ABAP, Automated, Functional, HTML, Java, Performance/Load, Software testing tools, Web
I currently use Microsoft’s ISA server to publish our web services and have done so for the past 3 years. It has been very stable and provided a great application level firewall for our applications. I would suggest that anything you choose have some type of application layer filtering and a 2 layer approach (i.e. [...]
View Answer | May 14, 2004 10:27 AM
Firewalls, Forensics, Incident response, Intrusion management, Network security, VPN, Web services, Wireless
I haven’t seen this problem, but just wondering if you’ve tried contacting Oracle support directly and/or tried placing a ticket with their Metalink portal for information on this problem. It has been my experience that they are very helpful with these kinds of issues.
View Answer | May 14, 2004 10:09 AM
AIX, Oracle, Oracle Application Server, SQL
If you need to hide values from people who is working in the same schema then your idea with wrapper does not work, because wrapper does not obfuscate literals. Since schema is the same then anybody can dig into wrapped package body and find values there. (By the way, starting from 9i you are prohibited [...]
View Answer | May 13, 2004 10:20 PM
View Answer | May 13, 2004 5:41 PM
1) can’t group by a column you don’t reference 2) the distinct may return more than one value
View Answer | May 13, 2004 1:51 PM
Hi Vijay. I am going to have to recite from the Gospel of Tom Kyte on this one: benchmark, benchmark, benchmark Do not just look at the query plan… tkprof your results to see the timing of these queries. Populate test tables with tens of thousands of rows (using a pl/sql script) and see how [...]
View Answer | May 13, 2004 1:01 PM
Oracle, Performance/Load, SQL, Tech support
Eric, I would have said Platinum but they got bought out by Computer Associates. So I would suggest Quest Technology or BMC. I would swing towards Quest most of the Platinum devolopment and support ended up working for them. Each company has toolsets that allow you to manage several diffent DBMS from one console. I [...]
View Answer | May 13, 2004 8:45 AM
Business/IT alignment, Data analysis, Database Management Systems, IT architecture, Knowledge management applications, Online transaction processing, Systems management software
Proceed as follows: SQL> SET LONG 100000 SQL> select trigger_body from dba_triggers where trigger_name = ‘NAME’; Here NAME stands for the trigger that you want to display. You can set LONG to any higher value if your trigger code is very long.
View Answer | May 13, 2004 8:29 AM
Probably one way would be to reset the variable to a default value after the initial processing.
View Answer | May 12, 2004 11:09 PM