Hi,
I have a stored procedure that works fine with SQL server 2005.
I am having trouble making the same thing work with Oracle 9i.
The SP was modified to some extent; but I still get errors...
Hello,
one of our Oracle USERID's has the role "BECOME USER". I saw in different documentations, that this role is allowing to become another users, themselve sys.
ENVIRONMENT: Oracle 9i, ...
Try to execute this script for last logon date or users but on a couple databases it just hangs... works for most of them though. Any idea why this is happening? (Oracle 8i and 9i.... SQL*Plus...
I have an unusual sitiuation where I need a user to pass the number of copies required for a report. The reporting tool is very limited, so I need to replicate the results in the query with ...
How to send a message to a port from oracle database?
In my scenario, I have an external report server which is listening to a port (e.g. localhost, port no 5000) which will generate and pri...
We have a situation where we are connecting data silos with common APIs via packages. In one situation, the packages we want to introduce can be automatically generated based on the footprint...
I have submitted a job thru the Oracle Database using the job scheduler in the database.
It is a job to gather stats.
How do I check to see if this job is actually executing?
I submitted th...
Hi,
My application connects to Oracle9 database using JDBC driver. Recently I had some issues with the execution of prepared statement and I was advised to upgrade my JDBC driver to version...
I need the syntax for a Oracle Database link that offers the best security if a user needs to link to our database. We would like to be able to control the passwords and the user of the link s...
Iam trying to connect Netbeans 6 with my oracle 9i DB,
I have already add the driver classes12.zip from services -> databases -> Drivers.
Also I have already add oracle.jar by making new...
"ORA-29275 partial multibyte character. Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input.
Action: Ensure that the...
SQL> desc user_constraints;
Name Null? Type
----------------------------------------- -------- -------------------------
OWNER ...
I am having a problem adding a database to a tree in Oracle 9i.
Ive done a considerable amount of surfing, and most solutions suggest editing TNS, Listener, and SQLNet files, but no dice. I ...
I'm trying to access in Oracle Forms system. I can access it in IE. When I access the site in Firefox, 3.0.1, it asks me to install oajinit and provides a link. I download and install the f...
I am working on a business assessment involving Microsoft Access databases. One of the areas of concern is security. One of the developers with the business said that Microsoft Access is eas...
I am trying to run a query which include statement "where name <> ''" but Oracle seems couldn't retrieve those records. Should I change it to "where name is not null" instead? how do I compare...
I have following user definded datatype created
type DATA_TYPE is table of varchar2(1000)
index by binary_integer;
type KEY_VALUE is table of DATA_TYPE
index by binary_integer;
...
Here is my sql command which I have stored in gather_table_stats.sql
exec dbms_stats.gather_table_stats
(ownname => 'BTOWATCH',
tabname => 'L_ATLAS_TETRAD_COVERAGE',
estimate_percent => 5...
Hello.. I am in need to guidance on a new project of mine:
"Company C" uses an Oracle database
(we are checking on the version). "Company B" needs to convert their data
over to a MS SQL ...
I deleted a directory which contained the default permanent tablespace. There was nothing on it that is needed. Now the database wil not do a normal shutdown. I've created a new default per...
Hi,
In oracle database in one table I have
id and count.
Through java application-for particular id
1.I check for id [select statement]
2.if id available -update the count.
if id not...
Hi Experts,
Clients wants me to refresh the PROD DB from standby database. Standby database is in Recovery Managed Mode.
So can I take any Backup(RMAN, Exp/Imp, Cold/Hot) of Standby database...
hello...
We are running oracle DB 9.0.2 and oracle developer 6i rel2 for the application we have developed on client/server based tecnology..
the listener status is blocked once i go to the ...
I tried inserting/updating a record that includes a Blob, but keep getting "java.sql.SQLException: ORA-00942: table or view does not exist". I'm just doing JDBC to an Oracle 9.2.0.7.0 databas...
I have defined a variable which is TABLE TYPE of variable. This variable holds all of results which is of course like a table. Now I want to write store procedue to pull out the results from t...
