Search results for query: *

I have a need to stop Oracle query. In pl/sql my task looks like declare lTestDate date; begin --moving through a cursor for f in (select /*+ first_rows*/ id, prev_id, time_stamp from my_table order by id desc) loop --checking some condition if...

I'm creating a kind of "on the fly" item validating/formatting with the mean of timer. The issue is that reading item value (even by calling name_in built-in) causes removing all trailing spaces. Does anybody know about workaround or other way to validate text item without leaving it? Regards...

I can not connect from my Forms 6i, patch 17 on XP SP1 to Oracle EE 9.2.0.5 on Solaris. I can connect from that Forms to 9.2.0.5 on HP. The same with other products from that 8.0.6 home. All settings seem to be correct, but I get coredump. I found a strange entry in sqlnet.trc file: nnfun2a...

Hi all. Does anybody know a way to connect to a specified instance of RAC? Both instances are with INSTANCE_ROLE='PRIMARY_INSTANCE' and configured for TAF and load-balancing. Regards, Dima http://seminihin.narod.ru

I need to select for each department a salary of a person with the longest record of service. I suspect that analytic functions (FIRST_VALUE?) may be used in some way but can't grasp how. The real task is more complex and I must avoid accessing "EMP" table more then once per "DEPT" row...

I have 2 tables, parent and child linked via foreign key (referencing field fk_field is indexed). Besides pk_field parent table contains quite selective and indexed field selective_field. child table contains some not quite selective though also indexed field nonselective_field. All indexes are...

I wrote a simple program that sends emails. The issue is that it takes about a second to process Transport.send(message). My network is OK and I may send at least 5 messages per second using mail command. Is this expected behaviour? Can I set any settings to speed it up?

I need to write data from xmldom.DOMNode variable to a varchar2 table field, but xmldom.writeToBuffer produces indentations that waste a lot of space. Is there any way to manage identations, preferably to get rid of them at all?

We're trying to recovere a database. We have hot backup of all datafiles except undo tablespace. Is it possible to get at least anything from such "backup"?

Hi, all Does anybody know a way to change (or even remove completely) indentation produced by xmldom.writeToBuffer? The size of "useful" data in my case is far less than 2K, but adding "formatting" spaces exceedes 4000 sql varchar2 limit. Regards, Dima http://seminihin.narod.ru

I have an XML containing <property name="dc" type="timestamp">17 March 2004 05:43:41</property> I need to convert it to <dc>2004-03-17</dc> Can anybody help me? Regards, Dima http://seminihin.narod.ru

Does anybody know a way to convert attribute name to uppercase? <xsl:template match="property"> <xsl:element name="[b]capitalize{@name}"> <xsl:apply-templates/> </xsl:element> </xsl:template> Regards, Dima http://seminihin.narod.ru

I'm creating SOAP client and the server application expects a text node with <> replaced by &lt;&gt; (that is IMO normally), but also with all double quotes - untouched. When I add text node containing those special characters, double quotes are all replaced by &quot;. Does anybody know how to...

Does anybody know a good technique for cloning (and switching) 24x7 database? Source is on NT, target is planned to be on Linux.Idle time should be minimized. Database is 8.1.7. Regards, Dima

Can anybody coment the following results: SQL> select dump('abc') from dual; DUMP('ABC') ---------------------- Typ=96 Len=3: 97,98,99 SQL> select dump(trim('abc')) from dual; DUMP(TRIM('ABC')) --------------------- Typ=1 Len=3: 97,98,99 SQL> select dump(a) from (select 'abc' a from dual...

Hi, I need to write pure sql query to extract a part of long column. I'm trying to use TO_LOB in conjunction with DBMS_LOB.SUBSTR, but get ORA-00932: inconsistent datatypes error. Does anybody have a clue or at least explanation of this behavior? Regards, Dima

Hi there, Does anybody know how to push optimizer hint into a view? I need to force using index on one of the inner view tables. I know it's possible, but can not remember syntax. create view v as select id, value from tab t; select /*+ index(smth I dont know)*/ id, value from v where id = 0...

Does anybody have an experience on running JSPs generated by Reports 9i? Can it be deployed to tomcat? All [un]successfull stories are highly appriciated. Regards, Dima

I've got this error: ERROR: Error from ejbc: Error while reading 'META-INF/weblogic-cmp-rdbms-jar.xml'. The error was: Unable to find bean 'QAT.Stock' in RDBMS CMP deployment descriptor 'META-INF/weblogic-cmp-rdbms-jar.xml'. The bean references this descriptor, but the descriptor doesnt...

Hallo, I've got a DLL and header file, that contains extern &quot;C&quot; { //some other delarations __declspec(dllexport) int __stdcall myfunc (unsigned char*& p1); typedef int (__stdcall* PROCESS)(unsigned char*); } It's apparently for C++, but I need to use it in C program I replaced this...