Oracle 10g

I want to conect oracle form 6i to oracle 10g data base

I want to connect Oracle form6i fmx to oracle 10g data base presently i am connecting at client side making shortcut in path i use to write :C:\orant\BIN\ifrun60.EXE c:\MS\FORMS\ERP_LOGIN erp_ss/ss@sdcl in this method End user is knowing User name and password and connecting string. Is there any...

Connecting SAP to Oracle Forms 6i

We run Oracle 10g with Oracle Forms 6i and trying to rid ourselves of some legacy C++ used for SAP connection. Is anyone using a SAP Adapter to connect to Oracle Forms? What are you using? Thanks. Moderator Note: This is a user submitted question

Hibernate with clob type

I am using clob of oracle 10 g in hibernate. When i tried to insert 5000lines of HTML code to the variable in jave, i am getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

Solution for ORA-6413 error showing connection not open

vb.net,oracle 10g

Oracle 9i to Oracle 10g Upgrade - Help needed for some PL/SQL errors

We are doing a Database server upgrade from Oracle 9i to Oracle 10g. As a part of this upgrade activity, I got in total three different PL-SQL Errors for which I had to make code changes in the database server. These errors were: (1) PLS-00371: at most one declaration for "string" is permitted....

how we call report through report

how we call report through report in 10g

Connection failure using dotnet 1.0 and Oracle client 10g with Oracle 10g server

Hi, I have application developed on dotnet 1.0 ( VS 2003) and Oracle 10g server. Client machine has windows XP ( sp2), Oracle client 10g, Oracle.net, mdac 2.6. ODBC connection is sucessful and using toad also i can connect client machine to server but using ditnet application (...

Get the following error when logging into SQLPlus - ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist

When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 10g Personal Edition Also getting the following error when trying to connect to an oracle database via VS2008 ORA-12514: TNS:listener...

How to store Form values in Oracle 10g with VB.NET

abt database storage in vb.net2005

Connectivity of Visual Basic 6 and Oracle 10g

Can u plzzz sugest me the code of how to connect Visual Basic6 and oracle 10g, I am facing problems while connecting. Plzz do reply at ur earliest. -Supriya

Developing standalone Apps with Oracle Developer 10g

hai, i am new to oracle 10g development. can i build an application using oracle forms developer 10g and run it without deploying in the application server.(i.e without using oracle 10g Application Server) thanks np

OracleClient

I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why??

Oracle 10g OCA dumps

I want to write OCA,need oracle 10g oca dumps?please help.

ProC under Oracle 10g

Hi! I have a piece of code in Pro-C that's been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty...

Oracle Data Dictionary

I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this...

Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)

CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); ...

oracle sync index job log file

Hi, I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job. the proble is: After i enable the log file option, ctx_output.start_log('SYNC_INDEXES_JOB.TXT');...

Upgrade from Oracle 10g2 to Oracle 10g4 on Linux

I'm a newbie to Oracle database administration and I've been recently tasked to upgrade our databases in our development environment from 10g2 to 10g4. The databases are housed on SUN servers (there are several database servers), running with RedHat Linux 4.5 operating system. Additionally, the...

Oracle 10g Reports not running

Hi Gurus, We are trying to migrate from form and reports 4.5 to 10g and while migrating them we were able to find the way to work with forms 10g but not with reports 10g from within forms. can any one give me the procedure to make reports 10g to work within forms . with example please.

32 bit to 64 bit oracle 10g

our company is having 32 bit applications (client/server(powerbuilder/oracle) and web (asp.net/php)) connecting to 32 bit server (oracle 10 g) . we are thining of migarting to 64 bit server . will it be any problem connecting to a 64 bit application with our exsisting appliacions(32 bit) thanks