Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sem
  • Content: Threads
  • Order by date
  1. sem

    How to interrupt Oracle 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...
  2. sem

    Making Forms not to trim text item

    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...
  3. sem

    8.0.6 client and 9.0.2 database

    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...
  4. sem

    Connecting to a specified node

    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
  5. sem

    Analytic functions?

    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...
  6. sem

    Bitmap conversion of B-tree indexes

    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...
  7. sem

    Performance of javamail

    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?
    • sem
    • Thread
    • Replies: 7
    • Forum: Java
  8. sem

    Canonicalizing xml

    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?
  9. sem

    Restore from hot backup without undo tablespace

    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"?
  10. sem

    xmldom and indentation

    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
  11. sem

    Change Date format

    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
    • sem
    • Thread
    • Replies: 11
    • Forum: XML
  12. sem

    Capitalize

    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
    • sem
    • Thread
    • Replies: 2
    • Forum: XML
  13. sem

    Problem with text node

    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...
    • sem
    • Thread
    • Replies: 0
    • Forum: XML
  14. sem

    Cloning 24x7 database to another platform

    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
  15. sem

    About char/varchar2 conversions

    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...
  16. sem

    Using DBMS_LOB.SUBSTR(TO_LOB(...

    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
  17. sem

    Hi there, Does anybody know how to

    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...
  18. sem

    JSP report

    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
  19. sem

    Error from ejbc

    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...
  20. sem

    *&amp; in header

    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...

Part and Inventory Search

Back
Top