SQL error

DECLARE BEGIN FOR C1 IN (SELECT A.BANK,A.BRANCH,A.MODULE,A.SCHEME,A.ACCOUNTNO,A.ACCOUNTISN,NVL(T.NEXTDUEDATE,:TDATE) NEXTDUEDATE,A.REVIEWDATE FROM ACCOUNTMASTER A,TERMLOANSDATA T WHERE A.BANK=:INPBANK AND A.BRANCH=DECODE(:INPBRANCH,'ALL',A.BRANCH,:INPBRANCH) AND A.MODULE=:INPMODULE AND...

Shindetanaji10 pointsBadges:

How many statutory charts can be linked to a primary operational chart?

We have a situation where we would like to establish a common operational chart for all countries. However, each country, and even each product line within a country, may have its own statutory chart. Can we map multiple statutory charts (and even multiple accounts within each chart) to a single...

SRMoscoe10 pointsBadges:

Connectivity between Oracle BI Publisher and Microsoft Access

I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

Ms123115 pointsBadges:

Delphi application freezing on search

We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

Archarish5 pointsBadges:

Changing BCP format file collation

Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

Db23290 pointsBadges:

Oracle 10g will not download to my Vista client machine

I have ThomsonTechnology Textbook Oracle 10g Database Administrator Implementation and Administration IBSN:-13 978-1-4188-3665-8. Oracle OTN website will not log on my Vista machine. I have been able to download Oracle 11g sucessfully.

Twolittlehorses4me10 pointsBadges:

OracleOraHome92HTTPServer Stopped

OracleOraHome92HTTPServer suddenly is not starting anymore, it is giving the below message: "Could not start the OracleOraHome92HTTPServer service on Local Computer. The service did not return an error. this could be an internal windows error or an internal service error. if the problem persists,...

Sous580 pointsBadges:

Run a business rule on save Hyperion

What are the rules for business rules to be run on save in a form?

Mlholly5 pointsBadges:

Take print of a report from Oracle 10g Form

how can i take print of report from Developer 10g Form.

Zain5 pointsBadges:

Accessing AS/400 DB2 physical files with Java

Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

GeethaNatarjan15 pointsBadges:

OMS user name

i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

Sous580 pointsBadges:

Error message during Oracle installation

when i install oracle appication service (portal,wireless,forms,reports) everything ok until cn=orcladmin password=.... a message error (error retrieving the oid administrator dn . please ensure that your oid connect inforation is correct) help pls ? thanks

Army125 pointsBadges:

Packet Write Failure error in Oracle 8.1.5

I am using Oracle 8.1.5 with MS Dot NET 2005 on Windows XP with service pack 2. When I am sending data through a stored procedure, it is giving the error of "TNS:12571 : packet write failure" but it’s adding record in table, but truncated data in some columns and no data in the rest of the...

BrentSheets6,940 pointsBadges:

“Oracle Client 11.1.0.6.0” Installation stuck at 33%

While installing oracle 11g client version of 11.1.0.6.0, I am unable to proceed. In "Oracle Universal Installer Window", the status of installation is stuck at 33% for many hours, it is not proceeding. Please Help

Orashezan5 pointsBadges:

Extracting data from multiple tables in Oracle 9i

I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS. I AM USING ORACLE9I .

Umrn15 pointsBadges:

OMS user name

i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

Sous580 pointsBadges:

DB2/400 field to match an Oracle VARCHAR?

We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

Michaelwpeak5 pointsBadges:

Size of temp tablespace in Oracle 9i

We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question

BrentSheets6,940 pointsBadges:

How can we pass Oracle username/password programmically?

i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.

Bina30 pointsBadges:

How can we call different canvases within one window?

i want to design a form with three canvases. but problem is occur that other two canvases are not shown at run time. i want to create a push button and when i press it then 2nd canvas must be open.

Bina30 pointsBadges: