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!

  • Congratulations TouchToneTommy 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: lorein
  • Content: Threads
  • Order by date
  1. lorein

    LOCK TABLE EXCLUSIVE, HELP!!

    Hi I have a procedure that update a record in a table. This table is accessed for many work stations and these stations update this table several times. In average this table is updated 900,000 times a day. My oracle version is 9.02 In this table there are no deletes. The records that are in...
  2. lorein

    ORA-31020 Invalid pl/sql DOM node list hdl.How can resolve this error?

    Hello I trying to parse an xml document. I'm using oracle 9i. This code for some nodes in the same document works. And for others don't l_parser2 := dbms_xmlparser.newParser; dbms_xmlparser.parseClob(l_parser2, l_clob); l_doc2 := dbms_xmlparser.getDocument(l_parser2)...
  3. lorein

    HELP How can I show 2 subreps inthe same section without overlapp?

    Hi I'm using crystal reprots 8.5 I make a report with 2 subreports in the same section, but these subreports are overlap. I try to resolve this issue inserting a new page after the report footer of the first subreport ,and add a new page after the report header of the second subreport, but it...
  4. lorein

    How could I know if there is no data in a report? Using CR 8.5

    Hi I have a VB 6 application using crystal reports 8.5 and the crystal OCX. My data base is oracle and i'm using stored procedures. I want to know if a report has data or not in order to have some text in the report instead a blank page. Does anybody know how do this?? I really...
  5. lorein

    I need help for Error 20534 in Crystal 8.5 using Oracle9i

    Hi I have some reports in crystal 8.5 using a VB 6 interface and my databse is oracle 9i. My problem is when I tried to excecute a report send me the error "20534. Error detected by databased DLL" I don't know why this happend, because some times fails and some times the report works...
  6. lorein

    How can I send a parameter to a stored Proc in a subreport ????

    How can I send a parameter to a stored Proc in a subreport ???? I'm using Crystal reports 8.5, oracle 9i and VB6. I'm using the OCX from crystal. My reports uses oracle stored procedures The problem is when I call a report from my VB application and this report has subreports I don't know how...
  7. lorein

    How Crystal Reports 8.5 can use an Stored proc in Oracle 9i

    Hi I need your help!!! I make a package with one SP in oracle 9i, I take this code from an example in seagate page, and also create the table CREATE OR REPLACE PACKAGE Test_Package AS TYPE Test_Type IS REF CURSOR; END Test_Package; / CREATE OR REPLACE PROCEDURE Test_Procedure ( Test_Cursor...
  8. lorein

    How connect crystal reports 8.5 to oracle data base

    Hi I'm using VB 6 and Crystal control (cristl32.ocx) I'm trying to connect to a oracle 9i data base, some times I can do it and some times not with the same code . I don't understan why if I dont change the code. This is the conection string that i'm using: With CrystalRep .Reset...

Part and Inventory Search

Back
Top