Hi Friend
I want to drop a job that is schedule to run a procedure
what is a command I need to use to drop the job.
Thanks
I want to test my stored procedure with TOAD.
Anyone who can tell me how???
When i right click on the stored procedure and select Execute procedure
I am presented with a dialog where to...
I need help resolving this error. I got this error this morning on the new pc I am setting up. As far as I can remember it was working yesterday when I shut down. After I got this error I bl...
What is the difference between them, can i include procedure and function with in package?
How can i execute package, like i used to execute procedure by execute Procedure_name;
Please exp...
Hi,
I have table with 3 million records. I am using ado with vb to get the data from the oracle database. I wish to limit the records returned by the query to 200 so that it takes less time f...
Hi Xperts,
In my Oracle 9.2.0.3 I have 1 table (tab1) with 2 cols (col1 as XMLType and col2 as CLOB). I Inserted in both fields the following same XML data :
<?xml version="1.0"?>
<TAB...
Hi,
I am using Oracle SQL *Plus....
(1) How can I select the role(s) that a user has been assigned....?
(2) How can I see all the 'grants' that have been assigned to a role....?
(3...
Hi Guys,
Is possible extract only stored procedures from a oracle export file (.dmp) ?
if yes, tell me how please
thanks
Have a Happy New Year
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 ...
I have a procedure that I have written that works. Unfortunately some of the data that it returns is 'Null' and hence the corresponding update fails. I want to write exception handling that wi...
The only way to recover is from media backup? I know I cannot "rebuild" system datafile, but if I don't have a backup - I know shame on me!!! - Is there anyway to recover database????
We have a UNIX shell script that calls SQLPLUS but at the moment no way of knowing whether the call failed or not (if DB not available for example). Is getting a return value from SQLPLUS a r...
Hi,
Can any body tell me the differences between oracle database 10g and 11g and to what extent it supports on windows platform
I'd like to know how to: in sql plus
1. display table name,datatype of fields of a table
2. copy a table structure
Hi,
I' m using JSP and am trying to query a date range against an Oracle 9i database which has a date field containing the following format: 9/12/1998 12:31:45 AM
I'm using a preparedStat...
I know that the identifiers in Oracle were limited to 30 characters. I would like to know if this is still true? I need to know if this is true for all editions of Oracle.
Prefferably I n...
I got ORA-14400: inserted partition key does not map to any partition .
Here is sample of my code. What is wrong? Thanks.
PARTITION BY RANGE (year, month)
(
PARTITION PART_DM_200...
ORA-06508: PL/SQL: could not find program unit being called:
What would be the root cause of the error?
Do I have to check whether the procedure has been created or compiled?
SELECT text...
Hi Gurus,
I have a table WO as:
SQL> Desc WO
actstart date
actfinish date
estdur float
wonum varchar2(10)
....
In a package, I declare:
type actstart_tab_type i...
I have Table_A with Column AAAA.
The column A has referential integrity constraint: it is Pk of TableB
...
CONSTRAINT Table_A_FK209
FOREIGN KEY (AAAA)
REFERENCES AAAA (Table_B))
.....
folks
how do i cast a string value to integer or float in oracle ie the value
100.23 is a string field type in table A and i need to get it into tbale b as a float value using a trigge...
I'm a bit lost....
Completely totally lost to be honest!
All the info is right there on the web, but I'm too much of a beginner I guess: a beginning developer.
Done some courses SQL and PL/...
I have a hot backup script like below.. I put "ALTER SYSTEM SWITCH LOGFILE" in before I backup the controlfile ..
I am just wondering wht is difference between ALTER SYSTEM SWITCH LOGFILE an...
Greetings experts,
I'm trying to set up a simple bulk update using a record rowtype and a table of that record. I'm getting errors in the line where I do the fetch saying the SQL statement...
The client has sent us one .dmp file which has the complete database backup. We know that the username was admin and we have password for it.
The version of oracle being used is same ie 8.1....
