Hot Search: Go Launcher themth inventory movement report apple store debit card fraud user soa composer DAVE BARTEN PRODUCTION SERVICE ipod classic service failed to start frequently5aa default icloud settings
Home >Default > ORA-01002 in a report

ORA-01002 in a report

-0001-11-30 | Default
Advertisement
Hi,
Windows NT
Report 2.5
Oracle7
I have a simple repport with 2 querys:
Q1:
SELECT SUB_DIS.DISTRICT_CODE DISTRICT_CODE
,DISTRICT.NAME NAME
,SUB_DIS.NAME NAME1
,SUB_DIS.CODE CODE2
FROM SUB_DISTRICTS SUB_DIS
,DISTRICTS DISTRICT
WHERE DISTRICT.CODE = SUB_DIS.DISTRICT_CODE;
Q2:
SELECT LIC.SUB_DIS_CODE SUB_DIS_CODE
,LIC.SUB_DIS_DISTRICT_CODE SUB_DIS_DISTRICT_CODE
,MTRA.ID ID
,MTRA.MTRA_DATE MTRA_DATE
,MTRA.LIC_DIE LIC_DIE
,MTRA.DISCOUNT_AMOUNT DISCOUNT_AMOUNT
,MTRA.RESET_AMOUNT RESET_AMOUNT
,MTRA.RESET_AMOUNT-MTRA.DISCOUNT_AMOUNT NET_VALUE
FROM METER_LICENCES LIC
,METER_TRANSACTIONS MTRA
WHERE MTRA.LIC_DIE = LIC.DIE
AND MTRA.TRANSACTION_TYPE IN ('40', '41')
and MTRA.MTRA_DATE between NVL(to_date(:p_start_date, 'DD MON RRRR'), to_date( '01 JAN 1997', 'DD MON RRRR'))
and NVL(to_date(:cg$p_sysdate, 'DD MON RRRR'), sysdate)
The tow querys are linked by:
code2 = sub_dis_code
district_code= sub_dis_district_code
I get this error when I run the report for a specifique range date (from 01/11/06 to 01/12/06) If I ask for the sames report using a different period it seems to work.
Regards,
Message was edited by:
ASkika

Latest answer

Advertisement
What error? You did not indicate

Related recommended

ORA-01002 in a report

Hi, Windows NT Report 2.5 Oracle7 I have a simple repport with 2 querys: Q1: SELECT SUB_DIS.DISTRICT_CODE DISTRICT_CODE ,DISTRICT.NAME NAME ,SUB_DIS.NAME NAME1 ,SUB_DIS.CODE CODE2 FROM SUB_DISTRICTS SUB_DIS ,DISTRICTS DISTRICT WHERE DISTRICT.CODE = S [More]

-0001-11-30 Default

ORA-01002: fetch out of sequence error when using Oracle Thin Driver 9i with Weblogic 6.1

The simple program below is a client that executes a SELECT query - there are 13 rows in the table, of which 10 are printed when I run the program, then after that the ORA-01002 error is reported. I am not doing anything with LOBs, or updates. I've t [More]

-0001-11-30 Default

Oracle Report raises ORA-01002 Fetch out of sequence

ORA-01002 Fetch out of sequence in runtime execution of oracle report 3.0 and 2.5 in client/server environment. The same sql query works in sqlplus without any problem. If I change the criteria (where clause) the error sometime disappear. I can't exp [More]

-0001-11-30 Default

BUG: preview report template errors with ORA-01002

I've checked on my local install and on apex.oracle.com. I go into the Templates of Shared Components and filter on the Report Templates. Although the preview icon is displayed to allow me to preview the template, I always receive "ORA-01002: fetch o [More]

-0001-11-30 Default

Bug and Fix: Report Template Preview displays ORA-01002

Hi, omniscient All! Let me share some knowledge with you. There is an old APEX bug: BUG: preview report template errors with ORA-01002 Report Template Preview/Copy Error Template Preview Error: You can definitely see it in 4.0, 4.1, 4.2, 4.2.1 versio [More]

-0001-11-30 Default

ORA-01002 fetch out of sequence after suspend/resume transaction

Environment - WebLogic 10.0.2.0 - Oracle thin driver 10.2.0.2.0 I iterate throw elements of ResultSet. During that global transaction is suspended and resumed. Then invoking of next on ResultSet caused following exception "java.sql.SQLException: ORA- [More]

-0001-11-30 Default

ORA-01002

Hi!. I've got a problem with Reports 2.5. Sometimes when I call a Report from Forms an error success "ORA-01002 --> fetch out of sequence" and I don4t know what i have to do in order to resolve it. Thanks.Hi, I've seen this problem resolved i [More]

-0001-11-30 Default

ORA-01002-Error in Select ... for update

I would like to insert CLOB in a table (VP_EVENTS) with a primary key (eventid) with the following code: String content = "AAAAAAAAAAAAABBBBBBBBBBXXX"; PreparedStatement cs = this.con.prepareStatement("INSERT INTO vp_events (eventid,term,pa [More]

2015-10-11 Default

Re: BUG? APEX 4.0: ORA-20503 error editing report with 400+ columns

Hello Everyone. I've run into something quite strange and am hoping you can help me. I am using Apex 4.0.1 and Oracle version 10.2.0.5. I've created a "classical" report in which the underlying SQL is a very simple: select * from pvtabThe Oracle [More]

2015-10-11 Default

ERROR (ORA-01002)  when Ioading a table by UPDATE/INSERT

I get the error message ORA-01002 ( Fetch out of sequence ) when I am loading a table by UPDATE/INSERT. At de Runtime Audit Viewer the process of loading update a number of register, in that case 44.050 and to the left register I get the error messag [More]

2015-10-11 Default

Click Ranking

  • Help! 2010 imac 27" - Display doesn't work after long sleep

    I just recently started having this problem. I've had this iMac since 2010 with zero issues, but it seems like ever since I downloaded Yosemite, the screen won't work after the computer has been sleeping for a while. I have to hold the power button a

  • Mac keeps crashing to blank black screen how do I fix?

    I am having trouble with my macbook pro. It is 15 in mid 2010   Software  Mac OS X Lion 10.7.5 please help this problem keeps interupting at random times. Interval Since Last Panic Report:  94125 sec Panics Since Last Report:          10 Anonymous UU

  • Not able to see all the users in AL08.

    Hello all, We  have SAP ECC 6.0 installed on SOLARIS 10,database as oracle 9.2.0.6 We have installed and configure solaris cluster 3.2 for our production environment , one node installed with database ( db+ci ) and other node installed with applicati

  • AV failure... "Failed to respond" error

    Been suffering from this "failed to respond" error for attempted video connections for some time now. Never quite got a solution for it. I have a PB 12" and iMac mini routed at home through a Netgear WPN824 unit, and now adding a MacBook. W

  • Why aren't all the products showing up in my application manager

    I know there is probably a simple answer to this but for some reason not all of the CC products are showing up in my application manager. Here is a list of the products that I do have access to right now: Photoshop InDesign Flash Pro Fireworks Muse A

  • Link Error Linux AS3: undefined reference to `oracle::occi::Environment

    I got this error when i try to run sample database access using OCCI libraries. test.cpp:21: undefined reference to `oracle::occi::Environment::createEnvironment(oracle::occi::Environment::Mode, void*, void* (*)(void*, unsigned int), void* (*)(void*,

  • Archive file cannot be opened for write program

    Hi All, I am getting the error message "annot be opened for write program" in log view, when I am trying to write data into archive file using "write' function. Please provide us the solution for this problem.Hello, It must be due to missin

  • Career in SAP after 42 Years

    Dear Experts, I'm in a dilemma over entering into domain of SAP at 42 years age. I'm a BCom Degree holder working in a IT company in Finance Department having 10 years of experience in Finance only.  I am in AP Function.  I am now 42 years planning t

  • How can I disable mac pro OSX 'spaces' shortcut keys? (i.e. CTL, Right Arrow)

    How can I disable mac pro shortcut keys: CTL right arrow, CTL left arrow, CTL up arrow, CTL down arrow? Currently, they take me from one space to another. (OSX 10.6) Goal is to use these shortcuts for text editing.Hi, Simon. You can instruct iTunes a

  • Which oracle table stores the TCP/IP port for a database sid?

    Hi Experts, There is a way to get the host name and host address of a database. SQL> select utl_inaddr.get_host_address from dual; GET_HOST_ADDRESS 10.xxx.xxx.xxx SQL> select DB_UNIQUE_NAME from v$database; DB_UNIQUE_NAME mydb Is there any similar w