How can you execute a SP in Oracle?
You can do Exec nameof SP parameters ( EXEc updaterecord 100,198,A ) in SQL server.
I made a full database export from which i'm trying to import some users.
Getting errors:
psdwd /ustage/backup/dwtestdb $ exp warehouse/warehouse FILE=outhouse.dmp OWNE
R=warehouse ROWS=y
...
I am creating a view in SQL PLUS. The view is using many table. I want to use a create a calculated field based 2 dates fields (one of which is displayed in the view and one that is not).
...
Running SQL Plus on Oracle 10g.
When creating reports I find that column headings are truncated to the maximum length of the column data. This is causing problems becuase the data is to be...
I have a VARCHAR2(10) column which will always stores data of length 10 characters. 'Should' I alter this table to make it a CHAR(10), or does it not really matter? (I know the basic about t...
Hi,
I am new to Oracle...so facing some issue...any help would be appreciated.
whats wrong in the way I am creating the procedure below???
Hi all,
I try something rather simple and are stunned that this doesn't work.
Here is a quick test setup:
Create a table called cm_test with one column (varchar2[50]) and call it "An...
I'm getting the same error as reported in this question:
http://www.experts-exchange.com/Databases/Oracle/Q_20856553.html?query=export+error&clearTAFilter=true
EXP-00008: ORACLE error 9...
Hi
I can I find oracle patch is installed on the machine. Is there any table which I query?
Recommended patches on top of 10.2.0.3 should be: 6081550, 6081547,6267873,6043052,6375952, 50...
//CALL PROCEDURE
PROCEDURE GEN_LPC_DETAILS(
P_brncd IN LN02REP2.BRNCD%TYPE , //this is VARCHAR2(5)
P_modcd IN LN02REP2.MODCD%TYPE , ...
I am using Oracle 8i on SunOS 5. It is a datawarehousing system
I got the following error while running an application
alter table abc split partition PHMMAXVAL at (to_date('2008JAN...
I newly install Oracle 10g database on my PC. When I try to run the "emctl start agent" command from the dos prompt, I got the following error
EM Configuration issue. C:\oracle\product\10....
Hi guys,
The problem is related to error loging, when ever an exeception is raised in my procedure, I have to execute this unix command:
" logged -p local7.debug -t "DBA APPLICATION:" " F...
Greetings,
I found the following example on how to load XMl file into Oracle table from the experts site.
However, when I tried to replicate this example in my environment it didn't work ...
With what sql statement(s) can I delete all objects of a db in oracle 9i? (Without deleting and recreating the database)
Regards,
pb
Hi,
Question, I need to spool out to file in Sqlplus and do not want to specify the linesize as fixed. I am using the dbms_output package and am writting out multiple lines of varying len...
how to remove a datafile from a tablespace.
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
OS: Microsoft Windows Server 2...
I have Oracle9.2.x Enterprise installed on my computer. I have created the database and have created a user with certain admin privileges. When I try to create a table in sqlplus, I get the fo...
I have a select statement that uses a LONG datatype in the where clause and is producing the following error
Error on Select - ORA-00932: inconsistent datatypes: expected NUMBER - got LONG :-...
Hi All,
I have a CSV file which contains XML file paths. Using SQL loader i want to load the xml files specified in the CSV file into oracle database(as BLOB)
CSV file content
1,/home...
I don't get the output of "dbms_output" to the spool file tmp.log.
All I get is this: "PL/SQL procedure successfully completed."
How do I get output of pl/sql procedure into sqlplus spoo...
Hi,
I need to be able to export my Select stmt to a CSV file in my PL/SQL Stored Proc. I know how to do this from the command line using Spool, but I don't think I can do this via a SP. I ...
Hi,
Can anyone tell me the purpose of Resetting the logs..during DB recovery.
i.e..Alter database open resetlogs;
In which scenario we have to use this command and why?
Regards,
Hello,
We have a Windows 2000 Server that has Oracle 9.2 installed on it. We run an ASP Application on it. This morning users were getting the error - tns could not resolve service name on ...
